Re: How to insert records by descending order of date ...

In article <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.
|>
This doesn't really make any sense. Relational tables have no order associated with them, so even if you insert in order, a select won't have the order. The order by clause is only for the select. Received on Fri Sep 01 1995 - 00:00:00 CEST