数据表tb_score:
想实现的效果是:为null值的score在最上面,score要逆序排列
mysql思路:需要用到case when的思路
SELECT
*,
CASE
WHEN score IS NULL THEN
1 ELSE 0
END AS new_order
FROM
tb_score
ORDER BY
new_order DESC,
score DESC
数据表tb_score:
想实现的效果是:为null值的score在最上面,score要逆序排列
mysql思路:需要用到case when的思路
SELECT
*,
CASE
WHEN score IS NULL THEN
1 ELSE 0
END AS new_order
FROM
tb_score
ORDER BY
new_order DESC,
score DESC