/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 vote59 views1 answer
Print sum of values sql
SQL
6 votes99 views4 answers
Sqlite drop table
SQL
0 vote117 views1 answer
Select new table sql
SQL
1 vote52 views1 answer
Metada in sql
SQL
0 vote112 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote113 views1 answer
Query string starts with vowels
SQL
0 vote118 views2 answers
What is the default password for sql server sa
SQL
1 vote97 views2 answers
Postgresql list columns
SQL
17 votes104 views6 answers
Sql select distinct
SQL
0 vote108 views1 answer
Copy data from one postgres container to another
SQL