MSSQL分页问题

Question

mssql分页

Answer 1

row_number就是一个序列 你获取的是只是一条数据，应该用ntile吧

Answer 2

set @page_size='1';你自己设置的页面就是1条

Answer 3

declare @page_size int;
declare @page_num int;
set @page_size='15';
set @page_num='40'
select * from(
select user_names,
user_phone,prize,xianjin,got_xianjin,got_cellmoney,Province,City,user_area,favoriteMarket,favoriteClothe
 ,brands_F,bag_brands,favoriteR,bz1,(row_number() over (order by  bz1  desc)-1)/@page_size as rownum  from Question
 where prize in('xianjin','cellmoney') 
 ) t
 where rownum = @page_num - 1
  order by bz1 desc

Answer 4

declare @page_size int;
declare @page_num int;
set @page_size='1';
set @page_num='40'
select * from(
select user_names,
user_phone,prize,xianjin,got_xianjin,got_cellmoney,Province,City,user_area,favoriteMarket,favoriteClothe
 ,brands_F,bag_brands,favoriteR,bz1,(row_number() over (order by  bz1  desc)-1)/@page_num as rownum  from Question
 where prize in('xianjin','cellmoney') 
 ) t
 where rownum = @page_size  - 1
  order by bz1 desc