>;with cteRows as (select *, row_number() over (partition by ClientID order by AddedDate DESC) as RowNumber >from Invoices) > >delete from cteRows R where RowNumber = 1 and Status = 'Completed' >and exists (select * from cteRows where RowNumber = 2 and Status = 'Completed' >and R.ClientId = cteRows.ClientId)Thanks
