如何删除SQL Server中的重复序列号？

I have one BOM table in SQL Server 2012. I need to remove some middle layers because they have the same serial numbers. Following is the structure of current state and desired result. Can someone help in giving the SQL query or filter logic? See enclosed image for formatted table.I have one BOM table in SQL Server 2012. I need