SQLServer
select top 2 * from User;
MySQL
select * from User limit 2;
Oracle
select * from (select rownum as r from User) User as user where user.r>50 and user.r<100;
DB2
select * from User fetch first 2 row only;
常用数据库,取前几条数据SQL语句
最新推荐文章于 2023-07-26 08:57:23 发布

2338

被折叠的 条评论
为什么被折叠?



