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 vote357 views1 answer
T-SQL Create Trigger
SQL
0 vote331 views1 answer
Count the table indatabase
SQL
0 vote359 views1 answer
Postgres row expiration
SQL
5 votes376 views1 answer
Sql integer to serial
SQL
-1 vote340 views1 answer
Mysql #1064 error
SQL
0 vote354 views1 answer
Allow external access to mysql
SQL
0 vote365 views1 answer
What alter does in db
SQL
0 vote336 views1 answer
How to find database collation in postgres
SQL
4 votes413 views2 answers
Sql display today's date
SQL
2 votes349 views1 answer
How to insert string variable into sqlite database
SQL