/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 vote292 views1 answer
Tsql delete all rows
SQL
6 votes350 views3 answers
What is where in sql
SQL
1 vote288 views1 answer
SQL Integer devision
SQL
5 votes322 views1 answer
Oracle get ddl
SQL
7 votes287 views1 answer
Oracle pagination query offset
SQL
1 vote267 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote274 views1 answer
Sql server convert date to weekday
SQL
6 votes255 views1 answer
Phpmyadmin reset root password
SQL
1 vote286 views1 answer
Update mysql centos
SQL
0 vote286 views1 answer
Run mysql xampp shell
SQL