/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 vote332 views1 answer
Trigger value from maltiple table to single table mysql
SQL
-1 vote330 views1 answer
Count occurrences sql
SQL
0 vote387 views1 answer
Postgres list all triggers
SQL
-1 vote337 views1 answer
Sql oracle take only last results
SQL
0 vote344 views1 answer
Isnull in sqlite
SQL
0 vote349 views1 answer
Sql query tags
SQL
0 vote359 views2 answers
Sql count number of rows after group by
SQL
5 votes340 views2 answers
Get columns number sql
SQL
1 vote350 views1 answer
What is int in mysql
SQL
0 vote328 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL