Sorting number in multiple range usin MySQL

Question

I am developing an educational site with requires sorting by range of numbers. I need some help on how to sort my data into the range as listed below. 581 is the highest, 604 is the lowest. It starts with 604 to 582, and begin again with 1 until 581.

(Highest) 581 580 579.   .   . 3     2   1   582     .   .   .   602     603     604    (Lowest)

Strawberry · Accepted Answer · 2014-09-29 11:52:22Z

1

Here's one idea...

SELECT * FROM ints;
+---+
| i |
+---+
| 0 |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+---+

SELECT i,CASE WHEN i < 5 THEN 1000-i ELSE i END x FROM ints ORDER BY x;
+---+------+
| i | x    |
+---+------+
| 5 |    5 |
| 6 |    6 |
| 7 |    7 |
| 8 |    8 |
| 9 |    9 |
| 4 |  996 |
| 3 |  997 |
| 2 |  998 |
| 1 |  999 |
| 0 | 1000 |
+---+------+

You can also write this as...

SELECT i FROM ints ORDER BY CASE WHEN i < 5 THEN 1000-i ELSE i END;

answered Sep 29, 2014 at 11:52

Strawberry

34k14 gold badges43 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting number in multiple range usin MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related