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: How can we make distinct of one particular column!

Re: How can we make distinct of one particular column!

From: JAYABH <jayabh_at_aol.com>
Date: 1998/01/05
Message-ID: <19980105140501.JAA07906@ladder02.news.aol.com>#1/1

If I have understood your question properly, I think what you could do is

    Select col1,col2,col3
   from table
   group by col2

i.e you could use group by.
Thanks and Bye for now.
Tushar Received on Mon Jan 05 1998 - 00:00:00 CST

Original text of this message

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