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 only using group by and having clause.U dont have to use rownum and rowid
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 ...
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...
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