StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCan I order by multiple columns and somehow keep the ordering related between columns in MySQL?
text
Body
copied!<p>I know the title doesn't explain my question very well (if someone can come up with a better title then please edit it). Here's what I want to do, say I have the following table:</p> <pre><code>id | a | b | c ------------------ 1 | 3 | 3 | 3 2 | 20 | 40 | 30 3 | 40 | 30 | 10 4 | 30 | 10 | 15 5 | 10 | 15 | 6 6 | 15 | 6 | 20 </code></pre> <p>This is slightly truncated version, I have a few more columns to sort by, but the principle behind the data & my question is the same.</p> <p><strong>What I would like is to get the data ordered in the following way:</strong></p> <ol> <li>The row with the highest value in col a</li> <li>The row with the highest value in col b</li> <li>The row with the highest value in col c</li> <li>Followed by all remaining rows ordered by their value in col c</li> </ol> <p>So, the result set would look like:</p> <pre><code>id | a | b | c ------------------ 3 | 40 | 30 | 10 2 | 20 | 40 | 30 6 | 15 | 6 | 20 4 | 30 | 10 | 15 5 | 10 | 15 | 6 1 | 3 | 3 | 3 </code></pre> <p>Doing a </p> <pre><code>SELECT id, a, b, c FROM table ORDER BY a DESC, b DESC, c DESC </code></pre> <p>Obviously gives me a ordered first, then b and finally c, so the following <strong>(which is not what I need)</strong>:</p> <pre><code>id | a | b | c ------------------ 3 | 40 | 30 | 10 4 | 30 | 10 | 15 2 | 20 | 40 | 30 6 | 15 | 6 | 20 5 | 10 | 15 | 6 1 | 3 | 3 | 3 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload