Find Duplicate Records Query | Dataford Interview Questions

Your question is Find Duplicate Records Query. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Unity QA engineers review automated test results from Unity Test Framework runs. Duplicate records can inflate failure counts and make build-quality reports unreliable.

Write a PostgreSQL query to identify duplicate test-run records in the unity_test_runs table. The unique record identifier, run_id, must not be considered when determining whether two records are duplicates.

Requirements

Group records by platform, test_name, build_version, executed_on, and result.
Return only groups that occur more than once, including the duplicate count.
Sort the output by the grouping columns in ascending order.

PostgreSQL grouping should treat rows with matching NULL values in the same grouping column as duplicates.

Schema

unity_test_runs

Column	Type	Description
run_idPK	INT	Unique test-run record identifier
platform	VARCHAR(30)	Unity target platform
test_name	VARCHAR(100)	Unity Test Framework test name
build_version	VARCHAR(30)	Unity build version under test
executed_on	DATE	Date the test ran
result	VARCHAR(20)	Test outcome