Satish Vemula

in

Browse by Tags

All Tags » Server Products (RSS)
Sorry, but there are no more tags available to filter with.
Dummy tables for SQL in Oracle, MS SQL and DB2
Once in a while, you will come across scenarios where you would like to run a pre-defined function but not against a table. For example, you would like to know the date or perform some computations, but what if I don't want to use a user-defined table...
Select FIRST/TOP N rows in MS SQL, Oracle and DB2
How do you select the first N rows in various databases? A quick thing to remember is that rows are not stored in any particular sequence in a database. They can be placed in random data blocks in the database without any order whatsoever. If a query...