/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 vote315 views1 answer
Oracle sql all days except weekends
SQL
7 votes286 views1 answer
Sql management studio display line numbers
SQL
3 votes326 views2 answers
Sql add year to date
SQL
0 vote301 views1 answer
Mysql case when null
SQL
0 vote292 views1 answer
Sql server isnull function nor working count
SQL
0 vote304 views1 answer
Check connections to database postgres
SQL
0 vote317 views2 answers
Replace null with 0 in sql
SQL
1 vote252 views1 answer
Alter user mysql native password
SQL
4 votes301 views4 answers
Oracle tablespace tables list
SQL
5 votes288 views2 answers
Sql create tabel with primary key auto_increment code
SQL