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 -> Re: sql question - distinct

Re: sql question - distinct

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: 28 Nov 2006 16:33:03 -0800
Message-ID: <1164760383.795757.278990@h54g2000cwb.googlegroups.com> 





soalvajavab1_at_yahoo.com schrieb:


> The result of the following query is what I like to get:

>

> SELECT MAX(BFP_NUMBER), MAX(METER_NUMBER), UNIT_ID


> FROM  BMA_RENTAL_AGREEMENT_UPPER


> GROUP BY UNIT_ID


>

> but I do not need/want to have a group by FUNCTION MAX or any other

> group by function




given Galen's example: which values for BFP_NUMBER and METER_NUMBER
should be returned?



-ap
Received on Tue Nov 28 2006 - 18:33:03 CST












Original text of this message













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