Scenario SQL Question

Find Duplicate Rows Using CTE (Common Table Expression)

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

Problem Statement

Write a query using CTE to find duplicate employee records based on first_name, last_name, and email combination. Show only the duplicate records (not the first occurrence).

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