MySql数据库排序问题
select authseq , authstate , transtime from mgt.mgt_mauthqueue
ORDER BY
CASE
WHEN authstate='1' THEN 1
WHEN authstate='0' THEN 2
WHEN authstate='5' THEN 3
ELSE 4
END , transtime DESC
Order By 排序的高级引用
可自定义排序方式
select authseq , authstate , transtime from mgt.mgt_mauthqueue
ORDER BY
CASE
WHEN authstate='1' THEN 1
WHEN authstate='0' THEN 2
WHEN authstate='5' THEN 3
ELSE 4
END , transtime DESC
Order By 排序的高级引用
可自定义排序方式