Bank of America interview question
select only duplicated rows from specific table.
Interview Answer
Anonymous
Apr 5, 2014
select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)
2
select only duplicated rows from specific table.
Anonymous
select * from table where id in (select duplicated_var from table group by duplicated_var having count(duplicated_var) > 1)
Check out your Company Bowl for anonymous work chats.