Question d’entretien chez Bank of America

select only duplicated rows from specific table.

Réponse à la question d'entretien

Utilisateur anonyme

5 avr. 2014

select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)

2