/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

10 votes255 views2 answers
Linux command line import mysql database
SQL
3 votes248 views2 answers
Sqlite show table definition
SQL
12 votes249 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote255 views1 answer
How to connect pgadmin with excel
SQL
2 votes253 views1 answer
Oracle index size calculation
SQL
3 votes266 views1 answer
Set default today mysql
SQL
1 vote273 views1 answer
How to set up a trigger in sql
SQL
0 vote282 views1 answer
Python sql last insertend
SQL
0 vote297 views1 answer
Creating sqeuence in oracle database
SQL
6 votes253 views1 answer
Check Table Exists
SQL