/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

1 vote271 views1 answer
How to show index type in postgresql
SQL
2 votes209 views1 answer
Q operator in oracle
SQL
0 vote268 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote209 views1 answer
How to remove default in mysql
SQL
0 vote203 views1 answer
Sql remove first character from string
SQL
0 vote222 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
6 votes354 views1 answer
Sql insert values into table
SQL
0 vote231 views1 answer
Sql select lowest value row
SQL
0 vote285 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote226 views1 answer
How to set up an anonymous function to variable in swift
SQL