/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

17 votes334 views6 answers
Mysql import sql file
SQL
16 votes393 views3 answers
T-SQL Add Column
SQL
25 votes391 views6 answers
Import database mysql command line
SQL
0 vote367 views1 answer
Store case result sql
SQL
0 vote350 views1 answer
Mysql root permission denied lost
SQL
0 vote343 views1 answer
Sql bild in function
SQL
0 vote358 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote387 views10 answers
Sql statement checker corrector
SQL
0 vote334 views1 answer
Get created time of database psql 8
SQL
1 vote337 views1 answer
Sql avg group by
SQL