Question

我想给分页的sql语句里加个条件进行排序怎么办

String sql = "select top " + pageSize + " * from Books where CategoryId= " + typeId;
sql += "and Id not in(select top " + pageSize * (pageCount - 1) + " Id from Books with (index=PK_Book) where CategoryId=" + typeId + " )";

Answer 1

加就加罢！
外面SQL加，同时里面的嵌套SQL也加上就是了！