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.

 

[Chris R. Timmons]

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.