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

1 vote299 views1 answer
Can not connect to mysql server
SQL
-1 vote307 views1 answer
How to switch user in mysql
SQL
2 votes322 views1 answer
Postgresql update sequence next value
SQL
0 vote317 views1 answer
Sql server insert inner join
SQL
15 votes292 views2 answers
How to know the username of postgresql
SQL
1 vote324 views1 answer
Postgresql append array
SQL
0 vote308 views1 answer
Firebird where
SQL
2 votes311 views5 answers
SQL trigger
SQL
0 vote293 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
1 vote300 views2 answers
Sql multiline comment
SQL