TOP N For Oracle, SQLServer & MySQL
posted 2 April 2007, Monday
If you are like me and you are in Oracle, PostgreSQL, SQL Server, MySQL and Firebird. day in and day out its syntax for either of these RDMS can be inconsistant. I need a reference. Syntax to limit the results on a simple select vary among the RDBM's listed above.
So, here's a hint. Assuming a table of USERS, with fields userid, username, email.
SELECT userid, username, email
FROM users
WHERE ROWNUM <= 10
FROM users
WHERE ROWNUM <= 10
SELECT userid, username, email
FROM users
LIMIT 10
FROM users
LIMIT 10
SELECT Top 10 userid, username, email
FROM users
FROM users
SELECT userid, username, email
FROM users
LIMIT 10
FROM users
LIMIT 10
SELECT FIRST 10 userid, username, email
FROM users
FROM users