Re: order a date dual select

ghoy_at_plusconsultancy.co.uk (gareth hoy) wrote in message news:<82cb01aa.0212200337.6d636c43_at_posting.google.com>...
> I have the following dual select statement:
>
> SELECT '30-MAR-2001' Transaction_Date_LOV FROM DUAL UNION
> SELECT '06-APR-2001' FROM DUAL UNION
> SELECT '12-APR-2001' FROM DUAL UNION
> SELECT '20-APR-2001' FROM DUAL UNION
> SELECT '27-APR-2001' FROM DUAL UNION
> SELECT '04-MAY-2001' FROM DUAL UNION
> SELECT '30-MAR-2001' FROM DUAL UNION
> SELECT '06-APR-2001' FROM DUAL UNION
> SELECT '12-APR-2001' FROM DUAL UNION
> SELECT '20-APR-2001' FROM DUAL UNION
> SELECT '27-APR-2001' FROM DUAL UNION
> SELECT '04-MAY-2001' FROM DUAL UNION
> SELECT '11-MAY-2001' FROM DUAL UNION
> SELECT '18-MAY-2001' FROM DUAL UNION
> SELECT '25-MAY-2001' FROM DUAL UNION
> SELECT '01-JUN-2001' FROM DUAL UNION
> SELECT '06-JUN-2001' FROM DUAL UNION
> SELECT '08-JUN-2001' FROM DUAL UNION
> SELECT '15-JUN-2001' FROM DUAL UNION
> SELECT '22-JUN-2001' FROM DUAL UNION
> SELECT '29-JUN-2001' FROM DUAL UNION
> SELECT '06-JUL-2001' FROM DUAL UNION
> SELECT '12-JUL-2001' FROM DUAL UNION
> SELECT '13-JUL-2001' FROM DUAL UNION
> SELECT '20-JUL-2001' FROM DUAL UNION
> SELECT '27-JUL-2001' FROM DUAL UNION
> SELECT '03-AUG-2001' FROM DUAL UNION
> SELECT '10-AUG-2001' FROM DUAL UNION
> SELECT '17-AUG-2001' FROM DUAL UNION
> SELECT '24-AUG-2001' FROM DUAL UNION
> SELECT '31-AUG-2001' FROM DUAL UNION
> SELECT '07-SEP-2001' FROM DUAL UNION
> SELECT '14-SEP-2001' FROM DUAL UNION
> SELECT '21-SEP-2001' FROM DUAL UNION
> SELECT '28-SEP-2001' FROM DUAL UNION
> SELECT '05-OCT-2001' FROM DUAL UNION
> SELECT '12-OCT-2001' FROM DUAL UNION
> SELECT '19-OCT-2001' FROM DUAL UNION
> SELECT '26-OCT-2001' FROM DUAL UNION
> SELECT '02-NOV-2001' FROM DUAL UNION
> SELECT '09-NOV-2001' FROM DUAL UNION
> SELECT '16-NOV-2001' FROM DUAL UNION
> SELECT '23-NOV-2001' FROM DUAL UNION
> SELECT '30-NOV-2001' FROM DUAL UNION
> SELECT '07-DEC-2001' FROM DUAL UNION
> SELECT '14-DEC-2001' FROM DUAL UNION
> SELECT '20-DEC-2001' FROM DUAL UNION
> SELECT '04-JAN-2002' FROM DUAL UNION
> SELECT '11-JAN-2002' FROM DUAL UNION
> SELECT '18-JAN-2002' FROM DUAL UNION
> SELECT '25-JAN-2002' FROM DUAL UNION
> SELECT '01-FEB-2002' FROM DUAL UNION
> SELECT '08-FEB-2002' FROM DUAL UNION
> SELECT '15-FEB-2002' FROM DUAL UNION
> SELECT '22-FEB-2002' FROM DUAL UNION
> SELECT '01-MAR-2002' FROM DUAL UNION
> SELECT '08-MAR-2002' FROM DUAL UNION
> SELECT '15-MAR-2002' FROM DUAL UNION
> SELECT '22-MAR-2002' FROM DUAL UNION
> SELECT '28-MAR-2002' FROM DUAL UNION
> SELECT '05-APR-2002' FROM DUAL UNION
> SELECT '12-APR-2002' FROM DUAL UNION
> SELECT '19-APR-2002' FROM DUAL UNION
> SELECT '26-APR-2002' FROM DUAL UNION
> SELECT '03-MAY-2002' FROM DUAL UNION
> SELECT '10-MAY-2002' FROM DUAL UNION
> SELECT '17-MAY-2002' FROM DUAL UNION
> SELECT '24-MAY-2002' FROM DUAL UNION
> SELECT '31-MAY-2002' FROM DUAL UNION
> SELECT '07-JUN-2002' FROM DUAL UNION
> SELECT '14-JUN-2002' FROM DUAL UNION
> SELECT '21-JUN-2002' FROM DUAL UNION
> SELECT '28-JUN-2002' FROM DUAL UNION
> SELECT '05-JUL-2002' FROM DUAL UNION
> SELECT '12-JUL-2002' FROM DUAL UNION
> SELECT '19-JUL-2002' FROM DUAL UNION
> SELECT '26-JUL-2002' FROM DUAL UNION
> SELECT '02-AUG-2002' FROM DUAL UNION
> SELECT '09-AUG-2002' FROM DUAL UNION
> SELECT '16-AUG-2002' FROM DUAL UNION
> SELECT '23-AUG-2002' FROM DUAL UNION
> SELECT '30-AUG-2002' FROM DUAL UNION
> SELECT '06-SEP-2002' FROM DUAL UNION
> SELECT '13-SEP-2002' FROM DUAL UNION
> SELECT '20-SEP-2002' FROM DUAL UNION
> SELECT '27-SEP-2002' FROM DUAL UNION
> SELECT '04-OCT-2002' FROM DUAL UNION
> SELECT '11-OCT-2002' FROM DUAL UNION
> SELECT '18-OCT-2002' FROM DUAL UNION
> SELECT '25-OCT-2002' FROM DUAL UNION
> SELECT '01-NOV-2002' FROM DUAL UNION
> SELECT '08-NOV-2002' FROM DUAL UNION
> SELECT '15-NOV-2002' FROM DUAL UNION
> SELECT '22-NOV-2002' FROM DUAL UNION
> SELECT '29-NOV-2002' FROM DUAL UNION
> SELECT '06-DEC-2002' FROM DUAL UNION
> SELECT '13-DEC-2002' FROM DUAL UNION
> SELECT '20-DEC-2002' FROM DUAL UNION
> SELECT '27-DEC-2002' FROM DUAL
>
>
> When the select statement is run ther order these values are displayed
> are not in the order in which they are selected. How do i get the

And there is no guarantee they would. Read a little bit of relational theory.

> values on the order they have been selected i.e. date order.
>

Add

ORDER BY 1 to the end of your statement.

> Any help would be much appreciated.
>
> Gareth
Received on Fri Dec 20 2002 - 17:18:59 CET