Domanda di colloquio di Bank of America
select only duplicated rows from specific table.
Risposta di colloquio
Anonimo
5 apr 2014
select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)
2