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 vote260 views4 answers
How to drop all tables in sql
SQL
0 vote228 views1 answer
Expose db in virtualbox
SQL
5 votes277 views2 answers
Oracle apex debug mode
SQL
0 vote257 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote283 views1 answer
Check if record exists mysql
SQL
8 votes287 views1 answer
Oracle search code in packages
SQL
0 vote263 views1 answer
Call function in query sql server
SQL
7 votes260 views1 answer
Forge server hosting
SQL
0 vote286 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote278 views1 answer
How to change owner in postgres
SQL