怎么让sql查询结果按in里面的顺序排序如
select rolenmae from table_name where rolename in ('one', 'two', 'three');
希望返回结果排序为
one
two
three以前看过有人问过此问题 不过现在找不到那个贴了
select rolenmae from table_name where rolename in ('one', 'two', 'three');
希望返回结果排序为
one
two
three以前看过有人问过此问题 不过现在找不到那个贴了
用decode可以简化一点
select rolenmae from table_name where rolename in ('one', 'two', 'three')
order by decode(rolename,'one',1,'two',2,3)