《Mysql入門解析數據庫分頁的兩種方法對比(row_number()over()和top的對比)》要點：
本文介紹了Mysql入門解析數據庫分頁的兩種方法對比(row_number()over()和top的對比)，希望對您有用。如果有疑問，可以聯系我們。

?????????????????????? 一頁3條數據 取第一頁的數據
?? select * from (select *,ROW_NUMBER()over(order by id asc) as number from T_News ) as tb1
???? where number between 1 and 3;
第五頁的數據
?select * from (select *,ROW_NUMBER()over(order by id asc) as number from T_News ) as tb1
???? where number between 3*4+1 and 3*5;
?????????????????????? 自己設定每頁幾條數據和看第幾頁
create proc usp_fenye @geshu int,@yeshu int
?as
?? begin
???? select * from (select *,ROW_NUMBER()over(order by id asc) as number from T_News ) as tb1
???? where number between? @geshu*(@yeshu-1)+1 and @geshu*@yeshu;
?? end

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/6370.html