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 阅读(3) 评论(0) 编辑 收藏 举报
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 阅读(3) 评论(0) 编辑 收藏 举报