在MySQL中排序多个字段

本文介绍了在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