SELECT TOP " + end + " * FROM EPRecruitment WHERE id NOT IN( SELECT TOP " + end * (start - 1) + " id FROM EPRecruitment ORDER BY Id desc )ORDER BY Id desc怎么把这句sql改成正序排列呢
select * from (SELECT TOP " + end + " * FROM EPRecruitment WHERE id NOT IN( SELECT TOP " + end * (start - 1) + " id FROM EPRecruitment ORDER BY Id desc ) ) G order by g.id asc 这样看下 看怎么样
SELECT TOP " + end + " * FROM EPRecruitment WHERE id NOT IN( SELECT TOP " + end * (start - 1) + " id FROM EPRecruitment ORDER BY Id desc )ORDER BY Id
把排序去掉不就成了正序了么 还有必要加 order by id asc么???? (order by id asc)正序的话这个东西可有可无
这样看下 看怎么样