/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 vote210 views1 answer
Convert rows to string sql server
SQL
1 vote247 views5 answers
Postgresql difference between two dates in days
SQL
1 vote225 views1 answer
Altrer name column postgres
SQL
1 vote210 views1 answer
Type int in mysql maxlenght
SQL
2 votes216 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote231 views1 answer
Sql filter rows with condition
SQL
8 votes219 views1 answer
Today minus 15 days postgresql
SQL
0 vote226 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote213 views1 answer
How to use group_concat in sql server
SQL
3 votes233 views2 answers
Update part of a string in mysql
SQL