/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

2 votes259 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
-1 vote245 views1 answer
How to format tables in sqlplus
SQL
0 vote282 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote282 views1 answer
QUERY JPQL
SQL
0 vote290 views1 answer
Alter boolean column postgresql
SQL
0 vote274 views1 answer
Sql insert from excel
SQL
0 vote293 views1 answer
Compare subqueries oracle
SQL
1 vote267 views1 answer
Mysql view command
SQL
0 vote284 views1 answer
ORA-00942
SQL
0 vote275 views1 answer
Select amount weeks between two dates mysql
SQL