Pages

Thursday, March 3, 2011

Database : May I help u????

Select Top N records..........

Microsoft SQL Server
SELECT TOP 10 column FROM table

MySQL
SELECT column FROM table LIMIT 10

Oracle
SELECT column FROM table WHERE ROWNUM <= 10

DB2
SELECT column FROM table
FETCH FIRST 10 ROWS ONLY


2 comments:

  1. Kool concept, why dont u take this further with lot more examples??

    Will help during conversion projects

    ReplyDelete