/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 vote114 views1 answer
Create bakupd database sqlserver
SQL
0 vote136 views1 answer
Sql case when exists in another table
SQL
0 vote129 views1 answer
Mysql money value
SQL
0 vote148 views3 answers
Find below average salary in sql
SQL
5 votes132 views2 answers
Mysqldump password
SQL
0 vote158 views1 answer
Mysql conf.d exampel
SQL
0 vote142 views1 answer
Drop all triggers oracle
SQL
11 votes207 views5 answers
Update table from another table mysql
SQL
0 vote140 views2 answers
Alter table add multiple columns mysql
SQL
2 votes95 views1 answer
Sql group by different columns
SQL