Wednesday, January 7, 2009

SQL SELECT TOP N equivalent in ORACLE and MySQL

SQL Server:
SELECT TOP 10 product, descr, email
FROM products

ORACLE:
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10

MySQL:
SELECT product, descr, email
FROM products
LIMIT 10

No comments:

Post a Comment