Sol 3

When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant.  Until you switch database platforms that is!  Then you find the simple things no longer work.  Take for example the TOP clause used so often in MS SQL Server.  It does not work on Oracle.  <sigh/>

I've been digging into Oracle lately and am noting down the differences in the hopes it will help someone else down the road.  So, without further waiting, here are the examples to get the top 10 records for the different platforms:

• MS SQL Server
  

  SELECT TOP 10 *
    FROM [table]

• Oracle
  

  SELECT *
    FROM [table]
   WHERE rownum <= 10;

• MySql
  

  SELECT *
    FROM [table]
   LIMIT 10

• DB2
  

  SELECT *
    FROM [table]
   FETCH FIRST 10 ROWS ONLY;