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 vote202 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote180 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
2 votes168 views1 answer
Oracle sql concatenate results into string
SQL
0 vote155 views1 answer
Php delete database
SQL
0 vote165 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote169 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote183 views1 answer
Distinct data types in a table sql query
SQL
2 votes159 views1 answer
Mysql add boolean column
SQL
0 vote172 views1 answer
Sql last 7 days
SQL
0 vote180 views1 answer
Declare date variable sql
SQL