ORDER BY one col but if the value is the same ORDER by another col

Asked Jun 22 '17 at 20:30

Active Jun 22 '17 at 20:30

Viewed 33 times

I'm currently ORDERing my data by total (the column is datatype DECIMAL 10,2) which is fine, however if the total is the same then it needs to be ORDERED by epoch ASC so oldest dated totals (with my epoch timestamp) are displayed first if they're the same amount. Current mysql query:

SELECT email, total, epoch FROM data ORDER BY total DESC LIMIT 5

asked Jun 22 '17 at 20:30

user8190808

`ORDER BY total DESC, Epoch ASC` – Martin Smith Jun 22 '17 at 20:32
how embarrassing thanks – user8190808 Jun 22 '17 at 20:32
@MartinSmith, no need of specifying `ASC` since that's default – Rahul Jun 22 '17 at 20:43
@Rahul No need not to specify it either. – Martin Smith Jun 22 '17 at 20:46
@MartinSmith, didn't got you but saying this is way enough `ORDER BY total DESC, Epoch` – Rahul Jun 22 '17 at 20:48
1

@Rahul he is saying the only benefit to omitting `ASC` is saving yourself a few key presses at the expense of clarity. – Uueerdo Jun 22 '17 at 20:53
@Uueerdo, what clarity you are talking about? MySQL docs or spec clearly says the same ... then what more clarity required? – Rahul Jun 22 '17 at 20:57
@Rahul clarity of intent, and readability. Precedence of AND and OR are specified as well, that does not mean "A AND B OR C AND D" is easy to read. – Uueerdo Jun 22 '17 at 21:44
@uueerdo, that's a different thing all together – Rahul Jun 22 '17 at 21:46

ORDER BY one col but if the value is the same ORDER by another col

0 Answers0