/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

8 votes264 views2 answers
Safe update mode in mysql
SQL
8 votes257 views2 answers
Change name of colum in sql table
SQL
0 vote234 views1 answer
Mysql percentage of total
SQL
1 vote263 views1 answer
Postgresql escape single quote
SQL
15 votes270 views5 answers
If null mysql
SQL
0 vote277 views1 answer
Oracle sql all days except weekends
SQL
38 votes260 views4 answers
Count sql
SQL
10 votes253 views4 answers
Mysql one week ago
SQL
0 vote284 views1 answer
Check if mysql db is used
SQL
0 vote253 views1 answer
Mysql find db contarint
SQL