Sunday, July 15, 2012

SQL command - Returning TOP N Records

Microsoft SQL Server
SELECT TOP 100 column FROM table

MySQL
SELECT column FROM table
LIMIT 100

Oracle
SELECT column FROM table
WHERE ROWNUM <= 100

No comments:

Post a Comment