/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

2 votes189 views1 answer
Mysql list users on ubuntu
SQL
2 votes200 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote237 views1 answer
Doctors appointment
SQL
4 votes199 views2 answers
How to insert ip address in mysql using php
SQL
2 votes228 views2 answers
Create temporary table in mysql
SQL
0 vote221 views1 answer
T-sql delete view if exists
SQL
3 votes212 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote203 views1 answer
Count mysql server db tables
SQL
0 vote186 views1 answer
Mysql earlier than date
SQL
0 vote194 views1 answer
Find largest table in mysql database
SQL