/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 vote148 views1 answer
Jooq finding lastest value in table
SQL
3 votes220 views2 answers
Wp do sql query from function
SQL
0 vote183 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote190 views1 answer
How to get nth number in sql
SQL
1 vote171 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote181 views2 answers
Copy database mysql
SQL
1 vote206 views2 answers
How to add amount between date in sql
SQL
0 vote186 views1 answer
Cube oracle
SQL
0 vote205 views1 answer
Arithmetic expression in sql
SQL
0 vote169 views1 answer
Oracle sql winter time change
SQL