/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
Finding leap year in sql
SQL
1 vote139 views1 answer
Drop primary key oracle
SQL
2 votes137 views1 answer
How to show the whole table in sql
SQL
2 votes135 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote126 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
1 vote77 views1 answer
Oracle character set
SQL
0 vote123 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote132 views1 answer
Mysql pad zeros
SQL
2 votes131 views3 answers
Replace null in sql
SQL
11 votes138 views5 answers
Sql server reset identity
SQL