sql 查询第10条以后的数据
select top 10 *,(ROW_NUMBER()OVER(ORDER BY Number)) as rownum from [table]
where not Exists(Select top 10(ROW_NUMBER()OVER(ORDER BY Number))as n from [table])


什么也没有查出来，数据库里的数据是大于10条的！

[解决办法]

SQL code

select *from(    select *,rid=row_number() over (order by number)    from tb) twhere rid >= 10