SQL 排序,ORDER BY DECODE(字段1,'S',1,'A',2,'B',3,'C',4),字段2
扩展后多列按先后排序-https://help.fanruan.com/finereport/doc-view-2528.html