Duplicate emails
Easysqlgroup byhaving
Return every email that appears more than once in users (each email once in the result). Order doesn't matter.
Tables
- users (id INTEGER, email TEXT)
Example 1
users
| id | |
|---|---|
| 1 | a@x.com |
| 2 | b@x.com |
| 3 | a@x.com |
Expected result
| a@x.com |
Constraints
- 0 ≤ rows ≤ 1000
- Any row order is accepted
Submit checks your solution against 7 tests, including hidden ones.
SQL
-- Write one SELECT query. Tables: users SELECT