Mysql query where in select

SELECT *
FROM some_table
WHERE relevant_field IN
(
    SELECT * FROM
    (
        SELECT relevant_field
        FROM some_table
        GROUP BY relevant_field
        HAVING COUNT(*) > 1
    ) AS subquery
)

Source: stackoverflow.com

Similar codes

0 vote214 views1 answer
Mysql edit trigger
SQL
2 votes126 views3 answers
Postgres create view
SQL
1 vote74 views1 answer
Ms sql how to see active job current run time
SQL
1 vote118 views1 answer
Temp table vs variable table in sql server
SQL
0 vote133 views1 answer
Sql server pivot rows to columns
SQL
2 votes115 views1 answer
Drop table purge
SQL
1 vote112 views1 answer
Postgres set column equal to another
SQL
0 vote118 views1 answer
Oracle list datafiles
SQL
0 vote117 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote129 views1 answer
Systems sql
SQL