How to delete duplicate rows in SQL I have a table where the data is imported daily with different dates and I have ID's that have more than one row with the same data
How to delete duplicate rows in SQL I have a table where the data is imported daily with different dates and I have ID's that have more than one row with the same data
Please help
can you copy and paste a sample of data please to help up help you!
-------------------------- Get rich or die trying --------------------------
delete d from
(
select *, row_no = row_number() over (partition by esn, shipdate, model_code, supplierid order by esn)
from YourTable where ESN='270113179912138090'
) d
where d.row_no <> 1
Duplicate rows in SQL
Posted - 06/26/2012 : 13:26:45
