db2:
select * from tab fetch first 10 rows only
oracle:
select * from tab where rownum =10
sqlserver:
select top 10 * from tab
mysql:
select * from tab limit 10
db2:
select * from tab fetch first 10 rows only
oracle:
select * from tab where rownum <=10
sqlserver:
select top 10 * from tab
mysql:
select * from tab limit 10
posted on
2009-11-02 17:15
冬之鸟
阅读(
1616)
评论()
编辑
收藏
举报