select Top PageSize * From (select Top (PageSize * 1) * From admin Order id By ase) Order By Id desc
除了这个!
最好是可以兼容多表查询!如join on
select Top PageSize * From (select Top (PageSize * 1) * From admin Order id By ase) Order By Id desc
除了这个!
最好是可以兼容多表查询!如join on