/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

1 vote176 views2 answers
Sql insert timestamp
SQL
11 votes169 views2 answers
Oracle source code
SQL
1 vote167 views1 answer
Mariadb get column names from table
SQL
0 vote168 views2 answers
How to save result of sqlite query in a table
SQL
4 votes164 views1 answer
SQL order random
SQL
11 votes194 views2 answers
Set default column value sql
SQL
0 vote179 views1 answer
Psql check table fields
SQL
2 votes157 views2 answers
Oracle create table if not exists
SQL
0 vote192 views2 answers
Select index table oracle
SQL
20 votes187 views6 answers
Creating a table in sql
SQL