Select Top N records..........
FETCH FIRST 10 ROWS ONLY
Microsoft SQL Server
SELECT TOP 10 column FROM tableMySQL
SELECT column FROM table LIMIT 10Oracle
SELECT column FROM table WHERE ROWNUM <= 10DB2
SELECT column FROM tableFETCH FIRST 10 ROWS ONLY
Kool concept, why dont u take this further with lot more examples??
ReplyDeleteWill help during conversion projects
excellent....
ReplyDelete