/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

13 votes139 views2 answers
Sql count distinct group by
SQL
2 votes169 views1 answer
Oracle trace file
SQL
0 vote153 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote147 views2 answers
Sql query inner join 3 tables
SQL
-1 vote183 views1 answer
MYSQL stored procedure select from
SQL
0 vote156 views1 answer
Copy data from one postgres container to another
SQL
0 vote133 views1 answer
Mysql database is not starting in xampp
SQL
0 vote147 views1 answer
Normalization in database 2nd normal form
SQL
6 votes146 views1 answer
What is where clause in sql
SQL
0 vote139 views1 answer
Power bi find all ids not in other tables
SQL