|
--顯示前條數(shù)據(jù) select top(4) * from students;
--pageSize:每頁顯示的條數(shù) --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 |
|
|
