select *
from(
select *,rid=row_number() over (order by number)
from [table]
) t
where rid >= 10
转载于:https://www.cnblogs.com/dudumao/archive/2012/08/20/3339472.html
select *
from(
select *,rid=row_number() over (order by number)
from [table]
) t
where rid >= 10
转载于:https://www.cnblogs.com/dudumao/archive/2012/08/20/3339472.html