Delete Duplicates in SQL | Dataford Interview Questions

SQL: delete duplicate rows from a table

Asked in the R1 stage. Treat rows with identical inventory attributes as duplicates, retaining the row with the smallest id.

Output

Delete duplicate rows from inventory_snapshots.
Return the deleted rows with columns id, store_id, sku, inventory_date, quantity, and status.
The surviving row for each duplicate set must be the one with the smallest id.

inventory_snapshots

Column	Type	Description
idPK	INT	Unique inventory snapshot identifier
store_id	INT	Walmart store identifier
sku	VARCHAR(20)	Stock keeping unit
inventory_date	DATE	Date of the inventory snapshot
quantity	INT	Recorded inventory quantity
status	VARCHAR(20)	Inventory availability status

Your question is Delete Duplicates in SQL. Start with the requirements and the one table in the Question tab.

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

SQL: delete duplicate rows from a table

Asked in the R1 stage. Treat rows with identical inventory attributes as duplicates, retaining the row with the smallest id.

Delete duplicate rows from inventory_snapshots.
Return the deleted rows with columns id, store_id, sku, inventory_date, quantity, and status.
The surviving row for each duplicate set must be the one with the smallest id.

inventory_snapshots

Column	Type	Description
idPK	INT	Unique inventory snapshot identifier
store_id	INT	Walmart store identifier
sku	VARCHAR(20)	Stock keeping unit
inventory_date	DATE	Date of the inventory snapshot
quantity	INT	Recorded inventory quantity
status	VARCHAR(20)	Inventory availability status

Your question is Delete Duplicates in SQL. Start with the requirements and the one table in the Question tab.

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