/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 vote326 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote262 views1 answer
Oracle service name view
SQL
0 vote231 views1 answer
Mariadb list tables
SQL
1 vote254 views1 answer
Mysql history command
SQL
0 vote270 views1 answer
Mysql select statement after index
SQL
7 votes269 views3 answers
Foreign key oracle
SQL
1 vote276 views1 answer
Get create table query existing table mysql
SQL
3 votes262 views1 answer
Oracle revoke
SQL
1 vote273 views1 answer
OstgreSQL version
SQL
0 vote260 views1 answer
Sqlalchemy sequence postgresql
SQL