2 Replies Latest reply: Oct 24, 2012 7:40 AM by 800849 RSS

    Query to get the values

    800849
      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