Being used to SQL Server, I get messed up when moving to Oracle. For reference, here are equivalent top N queries in both environments:

SQL Server:

SELECT TOP 10 book_name, price*sales
FROM tblBooks;

Oracle:

SELECT book_name, price*sales
FROM tblBooks
WHERE ROWNUM <= 10;

No related posts.