This discussion is archived
2 Replies Latest reply: Oct 24, 2012 5:40 AM by 800849 RSS

Query to get the values

800849 Newbie
Currently Being Moderated
Hi

I am executing the below query as

SELECT comapany
FROM TEST
UNION
SELECT 'ALL'
FROM DUAL
ORDER BY company ASC

Here are the result--:
comapany

All
Intel
Lava
Mana Lamp
Resti
Serv Prov

But we want to display the query result as

Intel
Lava
Mana Lamp
Resti
Serv Prov
All

Could you please help us on that.

Regards
Das

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points