常用数据库,取前几条数据SQL语句

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;

原文地址:https://www.cnblogs.com/geek/p/1422416.html