摘要:
简单的sql分页语句方法一:select top [pagesize] * from [table] where table.id not in (select top [pagesize]*[pageindex] table.id from [table])方法二:select top[pagesize] * from (select top [pagesize]*[pageindex] * from [table] order by table.id desc) t order by table.id语句比较简单,如果你有更好的意见或者建议请留言 阅读全文
posted @ 2012-03-03 21:18
kuangkro
阅读(317)
评论(0)
推荐(0)