2000及2005通用分页
摘要：
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 SourceTablewhere [Id] not in( select top 10 [Id] from SourceTable)3：MAX分页。select top 10 * from So 阅读全文
posted @ 2012-03-21 15:13 JRoger 阅读(211) 评论(0) 推荐(0) 编辑