SQL row_number()

select *
from (select *,row_number()over(order by ID desc) as row from t_test where id < 5000)t
where row<=100

posted on 2022-06-23 16:32  qq1151219115  阅读(11)  评论(0)    收藏  举报