Scenario SQL Question

Find Duplicate Records and Assign Row Numbers

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

Problem Statement

Write a query to identify duplicate email addresses and assign row numbers to each duplicate group. This helps identify which record to keep and which to delete.

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