56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t_maskdata;
+------+------+
| a | b |
+------+------+
| 1 | 5 |
| 2 | 17 |
| 1 | 4 |
| 1 | 7 |
| 2 | 22 |
| 2 | 15 |
| 1 | 1 |
| 2 | 10 |
| 1 | 9 |
| 2 | 11 |
+------+------+
10 rows in set (0.02 sec)
mysql> select *
-> from t_maskdata
-> order by a,if(a=1,1,-1)*b;
+------+------+
| a | b |
+------+------+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 1 | 7 |
| 1 | 9 |
| 2 | 22 |
| 2 | 17 |
| 2 | 15 |
| 2 | 11 |
| 2 | 10 |
+------+------+
10 rows in set (0.34 sec)