如何让ORDER BY 按指定的顺序排序？

[GreenTLG]

表里有个列叫Type，是商品类别，就3种情况：S，A，B。现在我需要按照SAB的顺序排序，那位大侠能帮帮忙啊，

SELECT *
FROM tbl_test
ORDER BY "@#$$%#$%@$@#$@$@#@$这里应该咋写？"

两个表联合查肯定没问题，现在就是想如果单独用这个表的话。咋弄。多谢啦！！！！

[九斤半]

表里有个列叫Type，是商品类别，就3种情况：S，A，B。现在我需要按照SAB的顺序排序，那位大侠能帮帮忙啊，

SELECT *
FROM tbl_test
ORDER BY "@#$$%#$%@$@#$@$@#@$这里应该咋写？"
----------------------------------------------
换个方法
select * from table where type='S' union all
select * from table where type='A' union all
select * from table where type='B'

[昵称被占用了]

order by case type when 's' then 1
when 'a' then 2 when 'b' then 3 else 4 end

[eszuorenhui]

select *
from tbl_test
order by s+a+b

[昵称被占用了]

order by charindex(type,'SAB')

[freeliu]

select *(这里应该列出标的字段了，否则会包含自查询中的seq)
from (select *, case type when 'S' then 1 when 'A' then 2 else 3 end as seq from tbl_test) X
order by seq

[昵称被占用了]

这个效率差，虽然看起来简单

[chuifengde]

order by charindex(type+',','S,A,B,')

[xyxfly]

呵呵,我在另一個地方看的3種方法都全了
charindex
case

union all

[being21]

MARK!!!

[十一月猪]

全了
；）