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
) t
where rid >= 10