/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 vote160 views1 answer
Turnicate in mysql
SQL
1 vote162 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote182 views2 answers
Nested query
SQL
0 vote194 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote193 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
12 votes168 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote168 views1 answer
Postgres regex word boundary
SQL
2 votes199 views1 answer
Username sql
SQL
4 votes156 views1 answer
Oracle error compilation line
SQL
0 vote181 views1 answer
C# select Mysql
SQL