您的当前位置:首页正文

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

2023-07-16 来源:好走旅游网


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

排序后前10行:

db2 :

select * from table fetch first 10 rows only

oracle :

select * from table where rownum <=10

select * from (select * from tab order by field) tmp where rownum <=10

sqlserver:

select top 10 * from table

mysql:

select * from table limit 10

因篇幅问题不能全部显示,请点此查看更多更全内容