Information is Wealth...: July 2009

how to get top 10 rows in oracle and Sql Server

In Oracle:
select * from [table name] where ROWNUM <= 10

In Sql Server:
Select top 10 from [table name]