/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

1 vote228 views1 answer
Sql delete row with auto increment
SQL
0 vote232 views1 answer
Sql get number of days between two dates
SQL
0 vote254 views1 answer
Sql query to find percentage of null values in a table
SQL
2 votes227 views1 answer
Sql update alias
SQL
0 vote235 views1 answer
Mysql listing get a particu particular user firsdt
SQL
2 votes214 views1 answer
Create table with primary key
SQL
0 vote218 views2 answers
Drop check constraint in ms sql
SQL
0 vote254 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
2 votes252 views3 answers
Sql truncate table
SQL
21 votes235 views6 answers
Change column in mysql
SQL