/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

2 votes350 views1 answer
Oracle trace file
SQL
0 vote315 views1 answer
Mysql add comment to column
SQL
-1 vote309 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote314 views1 answer
Check for directory in bash
SQL
0 vote353 views1 answer
SQL Hello, [firstname] [lastname]
SQL
7 votes348 views6 answers
Mysql group concat
SQL
0 vote327 views1 answer
How get data from database if id not found then search another column
SQL
2 votes403 views2 answers
Python escape string for sql
SQL
1 vote330 views1 answer
Oracle update with sequence
SQL
0 vote302 views1 answer
Postgresql copy backup table
SQL