#63 Removing Duplicate Users by Email

Companies:

Cleverdata

Themes:

SQLAggregationSubqueriesPractice

It is necessary to:

Find duplicate accounts by email.
Remove duplicates by email, keeping the records created earlier.

create table t_user(
    id      bigserial, -- PK
    name    text,
    email   text,
    created bigint,
    updated bigint
);

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.