Interview Query

Duplicate Rows

4
Have you seen this question before?

Given a users table, write a query to return only its duplicate rows.

Example:

Input:

users table

Column Type
id INTEGER
name VARCHAR
created_at DATETIME
Next question: Greater Release Dates
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query