Showing posts with label Returning TOP N Records. Show all posts
Showing posts with label Returning TOP N Records. Show all posts
Monday, December 2, 2019
Returning TOP N Records
Returning only the first N records in a SQL query differs quite a bit between database platforms. Here's some samples
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
SELECT TOP 100 column FROM table
MySQL
SELECT column FROM table
LIMIT 100
Oracle
SELECT column FROM table
WHERE ROWNUM <= 100
Subscribe to:
Posts (Atom)