removing duplicates from table without using primary key

Posted by jest on Stack Overflow See other posts from Stack Overflow or by jest
Published on 2010-05-09T05:49:20Z Indexed on 2010/05/09 5:58 UTC
Read the original article Hit count: 237

Filed under:
|

hi! I've a table(TableA) with contents like this:

Col1

A

B

B

B

C

C

D

i want to remove just the duplicate values without using temporary table in Microsoft SQL Server. can anyone help me? the final table should look like this:

Col1

A

B

C

D

thanks :)

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server