相同的sql 分页查询结果

select * from
(
select ROW_NUMBER() over(order by id desc) as rowsid,name from _Customer
)
as T where rowsid between 1 and 10;

with datalist as
(
select ROW_NUMBER() over( order by id desc) as rowsid,name from _Customer
)
select * from datalist where rowsid between 1 and 10