1、案例:
select *
from dell
where ite <> 1
and flag = 1
order by CASE offer
WHEN 'a' THEN
1
WHEN 'g' THEN
2
WHEN 'j' THEN
3
WHEN 'f' THEN
4
WHEN 'q' THEN
5
WHEN 'ads' THEN
6
end
,time asc