/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 vote118 views1 answer
Insert thai language sql server
SQL
-1 vote167 views4 answers
Sql view postgresql
SQL
0 vote135 views1 answer
View to table
SQL
2 votes146 views1 answer
Power query concatenate
SQL
1 vote119 views1 answer
What is int in mysql
SQL
0 vote133 views1 answer
Mariadb cast null to 0
SQL
1 vote134 views1 answer
Oracle difference between two dates in years
SQL
0 vote136 views1 answer
Pl sql search saurce code
SQL
1 vote144 views2 answers
Foreign key set 0
SQL
0 vote166 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL