Union with header row with order by
SamBDec 4 2006 — edited Dec 4 2006select 'Heading1', 'Heading2'
from dual
union all
select col1, col2
from myTable
order by col1
The above query obviously does not work, is it possible to re-write the query so it does? To be more specific I want to select a header row that is always the first row returned but I want the rest of the rows to be ordered by one of the columns in the second query.