Re: How to insert records by descending order of date ...
From: ATAR SEN MITTAL <asmittal_at_ix.netcom.com>
Date: 1995/09/01
Message-ID: <427cq5$qj7_at_ixnews6.ix.netcom.com>#1/1
Date: 1995/09/01
Message-ID: <427cq5$qj7_at_ixnews6.ix.netcom.com>#1/1
In <426g3l$8h2_at_hpscit.sc.hp.com> "RAJESH V.R" <vrraj_at_india.hp.com>
writes:
>
>Hi,
>
>I need to insert say, 1000 records from table A into table B
>by descending order of A.some_date, where some_date is a date field.
>Since I cannot use order by clause in an insert statement,
>is there any other way of doing it ?
>
>Thanks and Regards,
>Rajesh V R.
>
May be you can try insert ....as select * from temp order by date...
I havenot tried this. Received on Fri Sep 01 1995 - 00:00:00 CEST