Could anyone help me to remove duplicate rows?

[TaeHo Yoo]

I have a table that has more than 1 milion rows so practically it is
impossible to remove all duplicate rows by hand.
Could you help me to remove those duplicate rows at all?
This table doesn't have primary key( identity ) column.

Say Table name => MyTable
Column => Col1,Col2,Col3
No primary key column here.

Thanks a lot in advance.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Chris R. Timmons]

TaeHo Yoo <yootaeho@yahoo.com> wrote in
news:#VBSQEzTDHA.1364@TK2MSFTNGP10.phx.gbl:

> I have a table that has more than 1 milion rows so practically
> it is impossible to remove all duplicate rows by hand.
> Could you help me to remove those duplicate rows at all?
> This table doesn't have primary key( identity ) column.
>
> Say Table name => MyTable
> Column => Col1,Col2,Col3
> No primary key column here.

Have you looked into using SELECT DISTINCT?

Hope this helps.

Chris.
-------------
C.R. Timmons Consulting, Inc.
[url]http://www.crtimmonsinc.com/[/url]