SQL中如何取得前10笔资料和中间10笔资料

1, 如何取得前 10 笔资料

SELECT TOP 10 * FROM 表名

2, 如何取得第 10 笔到第 20 笔之间的资料

select top 10 * from (select top 20 * from tablename order by id desc) order by id

或者

SELECT TOP 10 * FROM tb

      WHERE id NOT IN(SELECT TOP 10 * FROM tb ORDER BY ID)

      ORDER BY ID

或者

SELECT TOP 10 * FROM (SELECT TOP 20 * FROM tb ORDER BY ID) a ORDER BY ID DESC

或者

SELECT TOP 10 * FROM tb WHERE ID>(SELECT MAX(ID) FROM (SELECT TOP 10 ID FROM tb) a) ORDER BY ID

或者

select * from table_1 limit 11,20;