sqlservice 取得 6 到10 行数据

可解释为取不在前条数据中的前10条数据 及为6 到10条

select top 10 ROLEID,ROLENAME from TABLE t where roleid not in
(select top 5 ROLEID from TABLE t order by roleid) order by roleid;

 

内查询中select top 5 ROLEID from TABLE t order by roleid 只能是单列

如果写成select top 5 ROLEID,ROLENAME from TABLE t order by roleid 会报错