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 vote243 views2 answers
Mysql missin expression near on
SQL
0 vote246 views1 answer
Mysql faster delete
SQL
3 votes221 views1 answer
How to find names includes in sql
SQL
6 votes197 views1 answer
Phpmyadmin reset root password
SQL
1 vote203 views2 answers
Mysql update table from another table
SQL
1 vote222 views1 answer
Mysql show long running queries
SQL
2 votes203 views2 answers
Postgresql date at timezone
SQL
0 vote223 views1 answer
Can't connect to postgresql mac os
SQL
0 vote233 views1 answer
Mariadb create index if not exists
SQL
1 vote228 views1 answer
Search for replace in mysql
SQL