/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 vote214 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote162 views1 answer
Command line mysql xampp
SQL
4 votes148 views3 answers
Sqlite show columns
SQL
1 vote170 views1 answer
Mysql return text after a final full stop
SQL
0 vote176 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote149 views1 answer
Mysql pad zeros
SQL
1 vote175 views1 answer
Postgres select as csv
SQL
1 vote225 views3 answers
Showing all columns in an sqlite table
SQL
0 vote150 views1 answer
Plsql check for string in numeric
SQL
1 vote140 views1 answer
Oracle undo usage per session
SQL