1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| create table personne (id int,nom varchar(20),prenom varchar(20))
insert into personne values (1,'zinzindohoue','etienne')
insert into personne values (1,'zinzindohoue','etienne')
insert into personne values (2,'zinzin','eti')
insert into personne values (2,'zinzin','eti')
insert into personne values (2,'zinzin','eti')
select * from personne
;WITH CTE (id,nom,prenom,DoublonCount)
AS
(
SELECT id,nom,prenom,ROW_NUMBER() OVER(PARTITION BY id,nom,prenom ORDER BY id) AS DoublonCount
FROM personne
)
DELETE
FROM CTE
WHERE DoublonCount > 1
select * from personne |
Partager