sql排序按某字段值0,1,2输出
如以下sql,排序按照isSubmit的值0,1,2排序:
SELECT
*
FROM
Tbl
WHERE
1 = 1
ORDER BY
CASE
WHEN isSubmit = 0 THEN
1 ELSE 2
END ASC
sql排序按某字段值0,1,2输出
如以下sql,排序按照isSubmit的值0,1,2排序:
SELECT
*
FROM
Tbl
WHERE
1 = 1
ORDER BY
CASE
WHEN isSubmit = 0 THEN
1 ELSE 2
END ASC