查询大于10条的数据

select *
from(
    select *,rid=row_number() over (order by number)
    from [table]
) t
where rid >= 10