1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| DECLARE @t TABLE
(
nom VARCHAR(50),
prenom VARCHAR(50),
userid VARCHAR(50)
)
INSERT @T VALUES ('DUPONT','JUDIT','JLOZAxxxxx');
INSERT @T VALUES ('DURANT', 'RAQUEL','RARAQxxxxx')
INSERT @T VALUES ('JOBERT','LAURA', 'LGORDxxxxx')
INSERT @T VALUES ('JOBERT','LAURA', 'LBAYHyyyy')
INSERT @T VALUES ('TASSIN','Celine', 'CCRIExxxxx')
INSERT @T VALUES ('TARTUFFE','Roger','TROGxxxxx')
SELECT
DISTINCT
T.nom,
T.prenom,
T.userid
FROM @t AS T
INNER JOIN @t AS T2
ON T.nom = T2.nom
AND T.prenom = T2.prenom
WHERE T.userid <> T2.userid |
Partager