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: newbie : writing an efficient query

Re: newbie : writing an efficient query

From: <dn.perl_at_gmail.com>
Date: 4 Aug 2006 15:38:42 -0700
Message-ID: <1154731122.691679.98680@m73g2000cwd.googlegroups.com>


One more point which I have been curious about . Why doesn't 'distinct' work on composite fields?

Table t1 : a1 number, a2 number.
Entries : (1,11) (2,21), (2,22) (2,22) (2,23) (2,23)

               (3,33) (3, 33)

select distinct(a1, a2) from t1 ... does not work. How do I write that query? Received on Fri Aug 04 2006 - 17:38:42 CDT

Original text of this message

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