/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 vote229 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
2 votes225 views1 answer
Oracle sql drop table purge
SQL
0 vote247 views1 answer
Postgresql in vs any performance
SQL
0 vote242 views1 answer
Mysql workbench view
SQL
1 vote224 views2 answers
Sql select only row with the max date
SQL
0 vote231 views1 answer
SqlFunction does not exist
SQL
8 votes242 views1 answer
Unique vs primary key
SQL
0 vote218 views1 answer
What is the essence of SQL?
SQL
12 votes257 views2 answers
Select into insert sql server
SQL
0 vote236 views1 answer
Except in sql alchemy
SQL