/SQL/Sql select duplicates based on two columns

Sql select duplicates based on two columns

select s.id, t.* 
from [stuff] s
join (
    select name, city, count(*) as qty
    from [stuff]
    group by name, city
    having count(*) > 1
) t on s.name = t.name and s.city = t.city

Source: stackoverflow.com

Similar codes

1 vote173 views1 answer
Mysql history command
SQL
2 votes201 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote175 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote136 views1 answer
Postgres delete where id in
SQL
0 vote176 views1 answer
Call scalar valued function sql
SQL
2 votes194 views1 answer
Mysql shell insert into
SQL
0 vote196 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote175 views1 answer
Postgre admin slow
SQL
25 votes193 views6 answers
Import mysql database command line
SQL
0 vote184 views1 answer
Using GROUP BY in MySQL Join Table
SQL