/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

0 vote191 views1 answer
Sql server user permissions and roles
SQL
13 votes210 views1 answer
Sql join 3 tables on id
SQL
0 vote251 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote189 views2 answers
Sql join on comma separated field
SQL
0 vote139 views1 answer
Kannst du deine finger trainieren
SQL
0 vote183 views1 answer
Groupby error in mysql
SQL
7 votes186 views2 answers
What is sql clause
SQL
0 vote168 views0 answer
SQL
0 vote198 views2 answers
SQL FROM
SQL
20 votes181 views5 answers
Sql show tables
SQL