Delete duplicate rows with CTE

with cte as
(
	select advertisementid, DateTimeRequested, IPAddress,
    RN = ROW_NUMBER() OVER(Partition by  advertisementid, DateTimeRequested, IPAddress order by advertisementid) 
from RequestHistory
) delete from cte where RN > 1
Last updated: 7/1/2022 12:33:31 PM

Latest Updates

© 0 - 2025 - Mike Brind.
All rights reserved.
Contact me at Mike dot Brind at Outlook.com