Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query
Try:
select distinct col1, col2 from test;
oracleinform_at_yahoo.com (Gopal) wrote in message news:<1ed02c3a.0203110314.64225045_at_posting.google.com>...
> Hi,
>
> How to use distinct on 2 columns . For eg I have a table A with 2
> columns
>
> A B
>
> 1 Oracle
> 1 Oracle
> 2 ORACLE
>
> In the above example first 2 records 2 columns are equal hence I want
> only 1 record out of the 2 records , How to imply distinct on such
> records , not using the rowid .
>
> Rgds
Received on Mon Mar 11 2002 - 11:38:29 CST