My Visual Studio
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment