queriniere:

Try wrapping your SQL query inside another, and sort the outer one, something like:

select foo, bar, baz from (
   select 'a' as foo, 'b' as bar, 'c' as baz from dual
   union
   select 'f', 'q', 'z' from dual
   union 
   select 'x', 'y', 'z' from dual
)
order by bar
[download]

...roboticus

When your only tool is a hammer, all problems look like your thumb.

ORDER BY must be after WHERE (or GROUP BY or HAVING) of the last statement. You effectively have multiple statements thanks to the unions.