Always Get Better

Posts Tagged ‘sql server’

SELECT TOP N in Oracle

Friday, April 11th, 2008

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;


SEO Powered by Platinum SEO from Techblissonline