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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Getting unique names in a col

Re: Getting unique names in a col

From: Reza <reza_at_digital-dispatch.co.uk>
Date: 2000/08/09
Message-ID: <965816850.21341.0.nnrp-04.d4f07aaa@news.demon.co.uk>#1/1

I didn't what really want to do but I think "Select distinct xxx .. " could be your answer
Reza
"Bhavin Shah" <bhavinsh_at_aludra.usc.edu> wrote in message news:Pine.GSO.4.21.0008081911500.17738-100000_at_aludra.usc.edu...
> Hi,
>
> How do you get a list of unique names within a
> column in sql?
>
> Ex:
>
> Country
> -------
>
> USA
> USA
> Argentina
> Bolivia
> USA
>
> I would like to only return USA,Argentina,Bolivia.
>
>
> Thanks in advance.
>
Received on Wed Aug 09 2000 - 00:00:00 CDT

Original text of this message

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