本文介绍了在MySQL中排序多个字段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个包含2个字段DATE和IMPORTANCE的表.现在,我想在DESCENDING ORDER中对这两个字段进行排序,以便按IMPORTANCE在每个DATE中对行进行排序.例如,如果排序正确,则行应返回如下:
I have a table with 2 fields DATE and IMPORTANCE. Now I want to sort both these fields in DESCENDING ORDER so that the rows are ordered by IMPORTANCE for EACH DATE. For example, if sorted correct, rows should return like this:
Dec 3, 2010 - 10 Dec 3, 2010 - 10 Dec 3, 2010 - 8 Dec 3, 2010 - 7 Dec 3, 2010 - 3 Dec 3, 2010 - 1 Dec 2, 2010 - 10 Dec 2, 2010 - 9 Dec 2, 2010 - 3 Dec 1, 2010 - 8 Dec 1, 2010 - 5 Dec 1, 2010 - 5 Dec 1, 2010 - 4是否只有一种查询语句才能实现这种有效方法?
Is there an efficient way of accomplishing this with only one query statement?
推荐答案SELECT * FROM yourtable ORDER BY `DATE` DESC, `IMPORTANCE` DESC
更多推荐
在MySQL中排序多个字段
发布评论