FastPrepFind Duplicate Email Addresses
Problem · Database

Find Duplicate Email Addresses

● EasyZS logoZSNEW GRADONSITE INTERVIEW

Problem statement

The table employees stores one row per employee email record.

Return every email address that appears more than once. Comparison is exact and case-sensitive. Do not count or list unique emails.

Return one column named email. Order rows by email ascending.

What the interview report shared

The interviewer asked SQL to find duplicate email addresses.

employees
ColumnMeaning
employee_idUnique employee identifier
emailEmployee email address

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

employees

One row per employee email record.

ColumnTypeNullableDescription
employee_idPKIntegerNo—
emailTextNo—

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
emailTextNo—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

  • The employees table has between 1 and 10^5 rows.
  • employee_id is unique and non-null.
  • email is non-null and contains at most 200 characters.

More ZS problems