Delete duplicate rows using subquery in Sql server

Published --