SQL 分页

分页

select * from

(select *, Row_NUMBER() over(order by 列名) as num from 表) as t

where num between 1 and 5

order by time desc

存储过程

create proc usp_GetPage

@pageIndex int, --页码

@pageSize int, --页容量

@pageCount int output        --共多少页

as

declare @n int

select @n=COUNT(*) from 表

set @pageCount =ceiling(@n*1.0/@pageSize )

select * from 

(select *, ROW_NUMbER() over(order by 列名)as num from 表) as t

where num between(@pageIndex -1)*@pageCount +1 and @pageIndex *@pageSize 

order by 列

 

评论

3 楼 留下的祝福 2013-06-21  

性能很低哦

2 楼 yzsunlight 2013-06-20  

为什么不用row_num

1 楼 yzsunlight 2013-06-20  

为什么不用row_num