Information is Wealth...
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]
Home
Subscribe to:
Posts (Atom)