导航

2012年2月20日

SQL Server分页

摘要： 2000及2005通用分页。1:3次排序分页。select * from (select top 10 * from (select top 20 * from SourceTable order by [id] asc) as TempTable order by [id] desc) as RetTable order by [id] asc2：双TOP分页。select top 10 * from SourceTable where [Id] not in( select top 10 [Id] from SourceTable )3：MAX分页。select top 10 * from 阅读全文

posted @ 2012-02-20 17:10 夹心刺猬 阅读(137) 评论(0) 推荐(0)