select * from (
select row_number() over(order by id desc) as rowid,* from news
) tb where tb.rowid between 10 and 20
select * from (
select *,row_number() over(partition by (catalogid) order by [newsid] desc as t
from [newsIncatalog]
) a
where a.t<=5
order by catalogid,t
with 临时性视图(只对它下一条语句有效!)
with abc as(
select *,row_number() over(partition by (catalogid) order by [newsid] desc as t
from [newsIncatalog]
)
select * from abc where t=1 order by Catalogid,t