/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 vote178 views1 answer
Stored procedures example
SQL
0 vote141 views1 answer
Separator mysql
SQL
1 vote193 views3 answers
How to pass password to mysql command line
SQL
0 vote169 views1 answer
Postgres where
SQL
0 vote199 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote191 views1 answer
Sql cmd no truncate
SQL
10 votes173 views3 answers
Sql select between two dates
SQL
1 vote189 views1 answer
Mysql workbench in ubuntu 14.04
SQL
6 votes178 views2 answers
Clear a table in mysql
SQL
0 vote165 views1 answer
Mysql add root password
SQL