sql server的簡單分頁

--顯示前條數據

select top(4) * from students;

--pageSize:每頁顯示的條數

--pageNow:當前頁

select top(pageSize) * from students where sno not in (select top(pageSize*(pageNow-1)) sno from students);

--帶條件的分頁

select top (pageSize) * from students

where sno not in

(select top(pageSize*(pageNow-1)) sno

from students where ssex='男') and ssex='男';

 與Oracle的分頁有些大同小異，就不一一介紹了Oracle分頁連接https://www.cnblogs.com/yijieyufu/p/11148739.html