Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Aggregation stumper

Aggregation stumper

From: <maxmike_at_ibx.bc.ca>
Date: Fri, 15 May 1998 16:17:21 GMT
Message-ID: <6jhpqg$bfi$1@nnrp1.dejanews.com> 







I believe the following is not directly expressible in a single query:



"Customer names for customers that have at most 3 orders with the
average of order amounts greater than 2000"



In other words I need the average of the counted orders.



I'd love to be shot down in my belief! Any ideas?



-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading
Received on Fri May 15 1998 - 11:17:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US