/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 vote316 views1 answer
Sql server datetime
SQL
1 vote307 views1 answer
Postgresql last element of array
SQL
0 vote503 views2 answers
Create new table from existing table with data in sql server
SQL
11 votes345 views4 answers
Update row in mysql
SQL
2 votes359 views2 answers
Oracle create table if not exists
SQL
0 vote308 views1 answer
Oracle search columns in schema
SQL
0 vote319 views1 answer
Mysql root localhost run
SQL
0 vote311 views1 answer
Oracle enable chain
SQL
15 votes307 views3 answers
Create table with primary key auto increment in sql
SQL
1 vote310 views1 answer
Sqlite3 read only
SQL