Re: query trigger

From: drukqs <invalid.drukqs_at_NOpandoraSPAM.belgie>
Date: Wed, 21 May 2003 19:13:17 GMT
Message-ID: <Xns9382D7DD44346invaliddrukqspandora@195.130.132.65>

andrewst wrote in news:2901810.1053445949_at_dbforums.com:

> SELECT pcnr, n
> INTO :testblock.pc, :testblock.number
> FROM
> (
> SELECT pcnr, sum(number) AS n
> FROM orders
> GROUP BY pcnr
> ORDER BY sum(number) desc
> )
> WHERE ROWNUM = 1;
This gives this error when I compile:
Encountered the symbol "ORDER" when expecting one of the following .(),*@ and so on........

What shall I do? Received on Wed May 21 2003 - 14:13:17 CDT