db2,oracle,mysql ,sqlserver限制返回的行数

①db2

select * from table fetch first 10 rows only;

 

②oracle

select * from table where rownum<=10;

 

③mysql

select * from table limit 10;

 

④sqlServer

select top 10 * from table;

posted @ 2018-05-29 15:40  筱筱的春天  阅读(3221)  评论(0编辑  收藏  举报