From: Bhavin Shah <bhavinsh@aludra.usc.edu>
Subject: Getting unique names in a col
Date: 2000/08/08
Message-ID: <Pine.GSO.4.21.0008081911500.17738-100000@aludra.usc.edu>#1/1
Sender: bhavinsh@aludra.usc.edu
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Complaints-To: abuse@usc.edu
X-Trace: usc.edu 965787357 10825 128.125.253.184 (9 Aug 2000 02:15:57 GMT)
Organization: University of Southern California
Mime-Version: 1.0
NNTP-Posting-Date: 9 Aug 2000 02:15:57 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server


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.