Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Remove duplicates
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
![]() |
![]() |