数据库分页查询语句数据库查询

SELECT TOP 页大小  FROM table1 WHERE id NOT IN ( SELECT TOP 页大小(页数-1) id FROM table1 ORDER BY id ) ORDER BY id

SELECT TOP 页大小  FROM table1 WHERE id > ( SELECT ISNULL(MAX(id),0) FROM ( SELECT TOP 页大小(页数-1) id FROM table1 ORDER BY id ) A ) ORDER BY id

SELECT TOP 页大小  FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber, FROM table1 ) A WHERE RowNumber > 页大小(页数-1)

SELECT  FROM TT LIMIT 1,20
SELECT  FROM TT LIMIT 21,30
/
如果你是几千上万数据，就直接使用mysql自带的函数 limit的普通用法就ok了，如果是100万以上的数据，可能就要讲方法了，狼蚁网站SEO优化我们来做个百万级数据的分页查询语句.
mysql> select  from news where id>=(select id from news limit 490000,1) limit 10; //0.18 sec //很 明显,这 种方式胜出 .
mysql> select  from news limit 490000,10 //0.22 sec;
/

select  from sys_option limit 10,20 
select  from table [查询条件] order by id limit ?,? 

SELECT /+ FIRST_ROWS /  FROM
(
SELECT A., ROWNUM RN
FROM (SELECT  FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21