sql分页显示并排序

Question

String sql="select top ("+pageSize+") * from userinfo where id"
 +" not in(select top (("+(pageIndex-1)+")*"+pageSize+") id from userinfo)";

 

 

我想分页同时根据id进行排序desc

哪位帮我改改！

Answer 1

String sql="select top ("+pageSize+") * from userinfo where id" +" not in(select top "+(pageIndex-1)*pageSize+" id from userinfo order by id) order by id";