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 vote147 views1 answer
Implode in sql query
SQL
-1 vote78 views2 answers
On delete set default sql server
SQL
5 votes124 views1 answer
Oracle find foreign key dependencies
SQL
0 vote204 views1 answer
Mssql unique key accept nulls
SQL
0 vote139 views1 answer
Check database restore status sql script
SQL
0 vote119 views1 answer
Sql database connectivity
SQL
0 vote127 views1 answer
Sqlite higher or equal
SQL
1 vote126 views2 answers
Populate sql table with random data
SQL
1 vote211 views1 answer
Oracle current sequence value
SQL
0 vote126 views1 answer
Denormalise SQL command
SQL