/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 vote340 views1 answer
Oracle list index on table
SQL
0 vote345 views1 answer
Cast as decimal postgresql
SQL
1 vote347 views2 answers
How to search date in sql query
SQL
0 vote291 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote363 views1 answer
Select into table variable
SQL
0 vote392 views1 answer
T-sql delete view if exists
SQL
0 vote391 views1 answer
Oracle insert single quote in string
SQL
-2 votes362 views2 answers
Union vs union all in sql
SQL
0 vote373 views1 answer
Suhaib
SQL
1 vote361 views2 answers
Pad zero sql server
SQL