取出sql表中第31到40的记录(以自动增长ID为主键,表名:t)
sql server方案1:
SELECT top 10 * FROM t WHERE id NOT IN ( SELECT top 30 id FROM t ORDER BY id ) ORDER BY id;
sql server方案2:
SELECT top 10 * FROM t where id in( SELECT top 40 * FROM t ORDER BY id) ORDER BY id DESC;
说明一下,这里这条没有按从小到大排列,但是你可以在外面再排序一下。
mysql方案:
SELECT * FROM student WHERE id LIMIT 2,3
注意:2是从哪里开始,3代表是好多条
oracle方案:
SELECT * FROM (SELECT rownum r,* FROM t WHERE r <=40) t2 WHERE t2.r >30
如果要排序
SELECT * FROM (SELECT rownum r,* FROM (SELECT * FROM t WHERE ORDER BY id DESC) t1 WHERE t1.r <=40) t2 WHERE t2.r >30