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: Remove duplicates

Re: Remove duplicates

From: nick <nick-love_at_juno.com>
Date: Tue, 13 Mar 2001 02:30:11 -0000
Message-ID: <tar1hjh7b7tcaf@corp.supernews.com>

xiaomh wrote:
>
>
> I want to import 10000 entries to my database. There are some duplicates
 in
> them.
>
> What's the best way to remove them(duplicates)?
>
> Thanks in advance!
>
> select distinct column_name

  from table;

--
Posted via CNET Help.com
http://www.help.com/
Received on Mon Mar 12 2001 - 20:30:11 CST

Original text of this message

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