1、场景:当一个查询需要多个排序规则时怎么做?
2、desc 降序,asc 升序,默认升序
3、select * from t_test oreder by createtime ,cuorder desc
查询结果:首先时间排序优先,默认升序,然后按照cuorder降序排列
错误解释:首先时间排序优先,然后cuorder,依次按照降序排列
4、select * from t_test oreder by createtime desc,cuorder desc
查询结果:首先时间排序优先,降序排列,然后按照cuorder降序排列
5、select * from t_test oreder by cuorder ,createtime desc
查询结果:首先cuorder排序优先,默认升序,然后时间按照降序排列,
与select * from t_test oreder by cuorder asc,createtime desc查询结果一样。