常用sql语句收集

按照多列排序分页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 --如果上面是倒序，那么这里就是正序，下同

 )