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;