Hi There

I would like to know hoe to delete duplicate rows from a table eg

col1 col2 col3 col4 col5 col6 col7
HP 1 1 OCCUPIED 3 A CASKET
HP 1 1 OCCUPIED 3 B CASKET
HP 1 1 OCCUPIED 3 B CASKET
HP 1 1 OCCUPIED 3 C CASKET
HP 1 1 PRE-PURCH 3 D CASKET
HP 1 1 PRE-PURCH 3 E CASKET

I would like to delete all rows where col6 is the same ie B

Thanks

Greg

DELETE f
FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY Col6 ORDER BY Col1) AS recID
FROM Table1) AS f
WHERE recID > 1