/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 vote156 views1 answer
Hashpass
SQL
4 votes134 views3 answers
Sql find second highest salary employee
SQL
-1 vote167 views1 answer
Search all sql tables for a value
SQL
0 vote153 views1 answer
SQLServerException.makeFromDatabaseError
SQL
8 votes106 views1 answer
Similarities between ddl and dml
SQL
5 votes131 views1 answer
List foreign key oracle
SQL
4 votes133 views2 answers
Sql table
SQL
0 vote181 views1 answer
Postgres select from values
SQL
0 vote169 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
-1 vote169 views2 answers
Sql truncate number
SQL