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 vote262 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
2 votes262 views1 answer
Oracle list grants on package
SQL
0 vote267 views1 answer
Custom row number
SQL
0 vote274 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
3 votes267 views1 answer
Async await mysql nodejs
SQL
0 vote248 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote255 views1 answer
Oracle list user locked
SQL
0 vote248 views1 answer
Mysqlimport
SQL
17 votes260 views6 answers
Get last record in sql
SQL
-1 vote248 views1 answer
What is in operator
SQL