/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 vote336 views1 answer
Metada in sql
SQL
0 vote378 views1 answer
SQL query to verify the size of the table
SQL
2 votes357 views1 answer
Get first 2 letter in sql
SQL
0 vote342 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote358 views1 answer
Dasebase_url-postgres for windows
SQL
6 votes384 views4 answers
Mysql group by date
SQL
0 vote395 views1 answer
Oracle current timestamp insert statement
SQL
5 votes370 views5 answers
Sqlite install python
SQL
0 vote376 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote333 views1 answer
Full syntax inner join
SQL