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

sql question - distinct

From: <soalvajavab1_at_yahoo.com>
Date: 27 Nov 2006 16:12:38 -0800
Message-ID: <1164672758.134641.135240@h54g2000cwb.googlegroups.com> 





How can I apply DISTINCT only to the first column in this query:


     SELECT  DISTINCT UNIT_ID, BFP_NUMBER, METER_NUMBER
     FROM table_1





It applies it to all 3 fields now. Pls advise.
Received on Mon Nov 27 2006 - 18:12:38 CST












Original text of this message













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