/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 vote220 views1 answer
For row in sql database python loop
SQL
4 votes197 views1 answer
Refresh postgres config
SQL
0 vote202 views1 answer
Qt qsql check if table exist
SQL
0 vote187 views1 answer
Sql server split string and insert into table select
SQL
1 vote306 views1 answer
Oracle datafile max size 32gb
SQL
0 vote209 views1 answer
Postgresql inline table
SQL
0 vote264 views1 answer
Create table with timestamp mysql youtube
SQL
6 votes199 views2 answers
Postgresql restore from dump
SQL
0 vote210 views1 answer
Oracle execute immediate quotes
SQL
1 vote274 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL