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