实现表tabcol3字段按自定义的(2,3,4,1)的顺序排序:
select col1,col2,case when col3='2' then 1 when col3='3' then 2 when col3='4 then 3 when col3='1' then 4 end rank from tab order by rank
实现表tabcol3字段按自定义的(2,3,4,1)的顺序排序:
select col1,col2,case when col3='2' then 1 when col3='3' then 2 when col3='4 then 3 when col3='1' then 4 end rank from tab order by rank