Pergunta de entrevista da empresa Amazon
ID table with duplicate rows: id1,id2 Select only the duplicate rows.
Respostas da entrevista
Sigiloso
15 de abr. de 2021
SELECT ID FROM MyTable GROUP BY ID HAVING COUNT(ID) > 1
13
ID table with duplicate rows: id1,id2 Select only the duplicate rows.
Sigiloso
SELECT ID FROM MyTable GROUP BY ID HAVING COUNT(ID) > 1