Re: Problem with simple SQL query!

Terry Maguire wrote:

> Hi
>
> Sorry there were mistakes in the previous message
>
> Could any please help me with this SQL statement. It seems OK but it returns
> the following error:
>
> order by market_cap desc
> *
> ORA-00933: SQL command not properly ended
>
> Here is the statement:
>
> insert into t_sedol (sedol)
> select sedol from t_master_download
> where rownum<=246
> and country='United Kingdom'
> and downloaddate='01-DEC-92'
> order by market_cap desc;
>
> So basically I want to insert the 'sedol' value(s) into the table 't_sedol'.
> The 'sedol' value(s) is a SELECT query that chooses its data from the table
> 't_master_download'. When I remove the ORDER part of the statement it runs
> fine but the ORDER is essential. Can anyone help on this one?
>
> Regards
>
> Terry Maguire
> IIU
> IFSC House
> Custom House Quay
> Dublin 1
> Ireland
> e:Mail - tmaguire_at_nospam.tinet.ie
> ---Remove the nospam to e:Mail

Hello,

put the select statetement into brackets eg :

insert into hallo2 (select * from hallo);

Regards

Michael Received on Mon Oct 05 1998 - 00:00:00 CDT