/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 vote341 views1 answer
Sql reverse order of results
SQL
0 vote323 views1 answer
How to find top 3 salary in sql
SQL
3 votes318 views2 answers
Pl sql escape '
SQL
0 vote342 views1 answer
Where name ends in SQL
SQL
2 votes345 views1 answer
Oracle sql merge
SQL
2 votes389 views1 answer
Sql find not in list
SQL
0 vote321 views1 answer
Sql last 7 days
SQL
0 vote351 views1 answer
Mariadb datetime change to microseconds
SQL
4 votes322 views1 answer
What are the data types in sql
SQL
0 vote310 views1 answer
Stuff in sql server
SQL