#43

Duplicate Employee ID Detection

EASYAggregationPOSTGRESQL

Problem Description

You are analyzing an employee database that may have data quality issues. Your task is to find all employee IDs (`emp_id`) that appear more than once in the table. Return a list of duplicate `emp_id` values, ordered by `emp_id` ascending.

Topics

aggregation

Asked at Companies

atlassian

Solve This Problem

Sign up to access the interactive code editor, run test cases, view the editorial, and get AI-powered feedback on your solution.

Start Solving →