SELECT *
FROM t_test
ORDER BY
(num > 0) desc,
ABS(num) desc;
mysql 查询,正数降序排序,负数升序排序
最新推荐文章于 2024-04-26 13:29:49 发布
SELECT *
FROM t_test
ORDER BY
(num > 0) desc,
ABS(num) desc;