怎样列出第10条以后的记录?解决方案

怎样列出第10条以后的记录?要SQL语句[解决办法]select * from XXXwhere not[ID] in (select top11 [ID] fr

怎样列出第10条以后的记录?
要SQL语句

[解决办法]
select * from XXX
where not [ID] in (select top 11 [ID] from XXX order by [ID] asc) order by [ID] asc