3 Réponses :
Vous pouvez essayer d'utiliser l'expression case when
dans order by
clause
select * from tablename order by case when key='F' then 1 when key='W' then 2 when key='H' then 3 end
utilisez le décodage
order by instr('FWH',Key)
ou
select a.* from yourtablename a order by decode(Key,'F',1,'W',2,'H',3)
essayez celui-ci:
select * from table1 where key in ('F','W','H') order by case when key ='F' then 1 when key ='W' then 2 else 3 end;