分页语句:SELECT * FROM news n1 WHERE
(SELECT count(*) from news n2 where n2.nid<n1.nid)>= 10
AND
(SELECT count(*) from news n2 where n2.nid<n1.nid) <20;
(SELECT count(*) from news n2 where n2.nid<n1.nid)>= 10
AND
(SELECT count(*) from news n2 where n2.nid<n1.nid) <20;