HuanYue 发表于 2013-1-13 18:48:33

db2 oracle和sqlserver取前几行的语法

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
页: [1]
查看完整版本: db2 oracle和sqlserver取前几行的语法