Pergunta de entrevista da empresa Bank of America
select only duplicated rows from specific table.
Resposta da entrevista
Sigiloso
5 de abr. de 2014
select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)
2