1.Oracle
select * from table where rownum<=10
2.Sql server
select top 10 * from table
3.Myaql
select * from table limit 10
4. DB2
select column from table fetch first 10 rows only
1.Oracle
select * from table where rownum<=10
2.Sql server
select top 10 * from table
3.Myaql
select * from table limit 10
4. DB2
select column from table fetch first 10 rows only