/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 votes150 views2 answers
How to fetch data from database without last column
SQL
0 vote202 views1 answer
Bigrock database connection string
SQL
0 vote136 views1 answer
Compress sql file database ubuntu
SQL
15 votes154 views6 answers
Drop foreign key mysql
SQL
0 vote124 views1 answer
Create new schema mysql
SQL
3 votes122 views1 answer
Sql multiple column index
SQL
0 vote116 views2 answers
Soql last year
SQL
5 votes147 views1 answer
Oracle columns in all_tables
SQL
1 vote133 views1 answer
Sql server epoch to datetime
SQL
92 votes336 views6 answers
Substring
SQL