Domanda di colloquio di Capgemini
Write a query to retrieve duplicate records from a table?
Risposte di colloquio
Anonimo
9 giu 2023
SELECT column, COUNT(id_column) AS new_column FROM table_name GROUP BY column 1 HAVING COUNT(column 1)>1;
4
Write a query to retrieve duplicate records from a table?
Anonimo
SELECT column, COUNT(id_column) AS new_column FROM table_name GROUP BY column 1 HAVING COUNT(column 1)>1;