/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

1 vote173 views2 answers
Difference between in and between in sql
SQL
5 votes199 views5 answers
Sqlite install python
SQL
0 vote200 views1 answer
Sql declare variable single line
SQL
0 vote185 views1 answer
Find largest table in mysql database
SQL
0 vote196 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote183 views1 answer
Encrypt password postgresql
SQL
1 vote193 views1 answer
Mysql query where in select
SQL
9 votes207 views3 answers
Mysql show table column full description
SQL
4 votes198 views3 answers
NOT NULL SQL
SQL
0 vote190 views1 answer
Alter owner in PostgreSQL
SQL