方法一:
sql = "select top " & pagesize &" * from temp where id not in(select top "&(intpage-1) * pagesize&" id from temp order by gxrq desc) order by ordernumber desc"
方法二:
select top " + pageSize + " * from tableName where id > (select top 1 id from (select top " + pageSize * (pageIndex - 1) + " id from tableName
order by gxrq,id) as T) order by gxrq,id;
select top " + pageSize + " * from tableName where id > (select top 1 id from (select top " + pageSize * (pageIndex - 1) + " id from tableName
order by gxrq,id) as T) order by gxrq,id;
sql = "select top " & pagesize &" * from temp where id not in(select top "&(intpage-1) * pagesize&" id from temp order by gxrq desc) order by ordernumber desc"