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: Steve Howard <stevedhoward_at_gmail.com>
Date: 28 Nov 2006 10:01:40 -0800
Message-ID: <1164736900.834572.122090@j72g2000cwa.googlegroups.com> 






soalvajavab1_at_yahoo.com wrote:


>

> I want DISTINCT only applies to UNIT_ID but I also have data for

> BFP_NUMBER, METER_NUMBER  in each result rows.

>




I'm still not clear on what you want.  Using Galen's example above, do
you want to see...



UNIT_ID  BFP_NUMBER  METER_NUMBER


1        10          100
          11          101
2        12          102 





?



Regards,



Steve
Received on Tue Nov 28 2006 - 12:01:40 CST












Original text of this message













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