db2, oracle和sqlserver取前几行的语法
上一篇 /
下一篇 2013-06-24 09:36:34
/ 个人分类:小问题
db2:
select * from tab fetch first 10 rows only
oracle:
select * from tab where rownum <=10
排序后前10行:
select * from (select * from tab order by field) tmp where rownum <=10
sqlserver:
select top 10 * from tab
mysql:
select * from tab limit 10
收藏
举报
TAG: