Bonjour,
Je vois un truc du genre:


select T1.*
from MaTable T1
left outer join MaTable T2 on T1.label = T2.label and T1.id <> T2.id
where T2.id is null