Pergunta de entrevista da empresa Tata nexarc

“They asked me to write an SQL query to find duplicate records using GROUP BY and HAVING.”

Resposta da entrevista

Sigiloso

11 de dez. de 2025

SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;