Scenario SQL Question

Identify Records for Deletion (Keep Oldest, Delete Newest)

Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to identify which duplicate records should be deleted to maintain data integrity (keep oldest employee_id, delete newer ones). Show deletion candidates with reason.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping
DISTINCT & Removing DuplicatesSQL Fundamentals