直接示例代码:
根据correctstatus列的三种状态值排序
select * from GIS_FEATURECORRECTION
order by case correctstatus
when '待审核' then 1
when '待处理' then 2
when '已完成' then 3
else 4
end,
gis_featurecorrection_pkid desc;