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

?????????????????????? 一頁3條數(shù)據(jù) 取第一頁的數(shù)據(jù)
?? select * from (select *,ROW_NUMBER()over(order by id asc) as number from T_News ) as tb1
???? where number between 1 and 3;
第五頁的數(shù)據(jù)
?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;
?????????????????????? 自己設(shè)定每頁幾條數(shù)據(jù)和看第幾頁
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

轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/6370.html