mysql 如何以2个字段排序?

select * from (select* from user ORDER BY `num` DESC)group by 'time' order by 'time' DESC好像是这样 用group

select * from tablename order by col1,col2,col3

还可以指定每个列的排序顺序

select * from tablename order by col1 asc,col2 desc,col3 asc

你这样写是错误的,首先你应该再分析下你的需求,你的要求实际上就是先筛选出 tongji>tongji2 的数据,再排序,你那样写是错误的,order后面不能跟表达式

select * from $member where tongji>tongji2 order by tongji desc Limit 0,10

---