SELECT id, seconds FROM tableName
ORDER BY
CASE
WHEN seconds > -1 THEN 0
WHEN seconds = -1 THEN 1
ELSE 2
END
, seconds
查询结果:
SELECT id, seconds FROM tableName
ORDER BY
CASE
WHEN seconds > -1 THEN 0
WHEN seconds = -1 THEN 1
ELSE 2
END
, seconds
查询结果: