在MySQL中排序多个字段 [英] Sorting multiple fields in 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中排序多个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！