按照多列排序分页sql
select * from Plugin_Messages where Mes_ID in
( select top 30 Mes_ID from (select top 60 Mes_ID ,Is_Best, ReplyNums from --有几个排序字段就写几个字段
Plugin_Messages
where Mes_ID>0
order by
Is_Best desc ,ReplyNums desc,Mes_ID desc
) as aa
order by
Is_Best asc, ReplyNums asc ,Mes_ID asc --如果上面是倒序,那么这里就是正序,下同
)