Information is Wealth...: SQL
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

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]