Avatar of Milind Agarwal
Milind Agarwal
Flag for United States of America

asked on 

Removing the duplicate Rows SQL Server

Hello All,
I am trying to remove the duplicates from a table. Both rows are exact except one column that has a null. Avoiding a subquery.

Please find the attachment for more info. Removing the nulls from status column except when the subject has total.

Thanks in advance.

Thanks,
Milind
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon