Re: Help with query order

hasta_l3_at_hotmail.com schrieb:
> I cant get the results of the following query correctly ordered.
> Any help would be much appreciated (10.2.0.1)
>
> select 'Merry ' from dual
> union
> select 'Christmas ' from dual
> union
> select 'dear ' from dual
> union
> select 'group ' from dual
>
> --- Raoul :-)
>

select 'Merry ' from dual
union all
select 'Christmas ' from dual
union all
select 'dear ' from dual
union all
select 'group ' from dual

-- 
Firma/Company:                                              CRESD GmbH
Phone: +49-89-65 30 95 63                      Fax: +49-89-65 30 95 64
WWW:                                               http://www.cresd.de
S-Mail:                                Freibadstr. 14, D-81543 München
PGP-Key:                            http://www.cresd.de/edv/pgpkey.txt
Open BC (Einladung)            http://www.openbc.com/go/invita/4561755