AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 1 hour 34 min ago

Is it possible to print first 10 records of a table

Thu, 03/17/2016 - 00:00
Is it possible to print first 10 records of a table only using group by and having clause.U dont have to use rownum and rowid

Adaptive Dynamic Sampling

Tue, 03/15/2016 - 00:00
Team, Going through this paper http://www.soug.ch/fileadmin/user_upload/SIGs/SIG_150521_Tuning_R/Christian_Antognini_AdaptiveDynamicSampling_trivadis.pdf On the slide#22 able understand the single table cardinality adjustments (see that in ...

What is the fastest way to delete data from temporary table?

Sun, 03/13/2016 - 00:00
Hello, Tom, i'm using gtt during daily data uploading procedures. I have 10 procedures, that launches one by one. Each of this procedures uses 1 universal gtt (lets call it universal_gtt. Table contains 3 fields: id numeric, date1 date, date2 dat...

Material to read for Sql and to do efficient sql query

Wed, 03/09/2016 - 00:00
Hi, I am working on a project which is based on sql and sql script actually.Can you please guide me on the same. Can you please tell me from where i can read and try writing the query effeciently. Regards Sona

Pages