Oracle、Sqlserver与Mysqkll分页查询
OracleSELECT * FROM (
SELECT A.*, ROWNUM RN FROM (
SELECT * FROM TABLE_NAME ) A
WHERE ROWNUM = 21
Mysql
几千上万条数据直接用自带的limit函数就能解决
select * from table limit(m,n);//从m开始取n条数据，索引从0开始表示第一条数据，从m+1条数据开始取那条数据
如果是百万级别的数据就得换写法了
select * from table where (select * from table limit(500000,1) limit 10;
SqlServer
1、SELECT TOP 页大小 * FROM table1 WHERE>
2、SELECT TOP 页大小 * FROM table1 WHERE>
3、SELECT TOP 页大小 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY>
页:
[1]