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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using distinct across several columns

Re: Using distinct across several columns

From: Steve Wicklund <savant_7_at_hotmail.com>
Date: 14 Jan 2003 18:28:02 -0800
Message-ID: <5de96e4e.0301141828.2248c8be@posting.google.com> 





That will retrieve rows that are unique across only the *three*
columns-- and not order_number? I am looking for unique combination of
values across only three columns--- but still retrieve the value of
all four.


Cheers!
 




"Alistair Thomson" <thomson_alistair_at_no.spam.yahoo.co.uk> wrote in message news:<b01ar6$h38$1$8302bc10_at_news.demon.co.uk>...


> Hi

> 

> try

> 



 <truncated>




> > Cheers.

Received on Tue Jan 14 2003 - 20:28:02 CST












Original text of this message













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