string sql = "(select top " + pagesize * pageindex + " * from [news] where rootid=" + Type + " and show=1 order by top desc,creatdate desc)"; //先查询出pagesize和pageindex乘积的top有效数据 倒叙排列

sql = "(select top " + pagesize + " * from " + sql + " order by top,creatdate)"; //然后基于之前数据查询出正序top要选定行数的数据

sql = "select * from " + sql + "order by top desc,creatdate desc";//最后再倒叙排列

这样查询效率相对高一些