db2, oracle和sqlserver取前几行的语法

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