Domanda di colloquio di Amazon
ID table with duplicate rows: id1,id2 Select only the duplicate rows.
Risposte di colloquio
Anonimo
15 apr 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.
Anonimo
SELECT ID FROM MyTable GROUP BY ID HAVING COUNT(ID) > 1