Pregunta de entrevista de Bank of America
select only duplicated rows from specific table.
Respuesta de la entrevista
Anónimo
5 abr 2014
select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)
2