SQL SERVER大数据分页
时间:2022-03-10 17:32
select * from (select rownum r, a.* from (select * from table_name order by ndatetime desc ) a where rownum <= currentPage * pageSize ) where r > (currentPage - 1) * pageSize
SQL SERVER大数据分页,布布扣,bubuko.com
时间:2022-03-10 17:32
SQL SERVER大数据分页,布布扣,bubuko.com