/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 votes171 views1 answer
Query to find table size in oracle 12c
SQL
1 vote233 views1 answer
Create new table from old table with data
SQL
0 vote153 views1 answer
Oracle synonym procedure dblink
SQL
0 vote151 views1 answer
Postgresql regular expression special characters
SQL
0 vote185 views1 answer
Sparql if bound query
SQL
0 vote148 views1 answer
Oracle list dblink
SQL
0 vote161 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
5 votes106 views1 answer
Mongodb vs
SQL
16 votes146 views1 answer
Mysql mediumint max value
SQL
-1 vote150 views5 answers
Online sql to linq generator
SQL