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 vote153 views1 answer
Hibernate with springboot mysql
SQL
0 vote153 views1 answer
Login failed for login due to trigger execution
SQL
0 vote152 views1 answer
Pl sql join 3 tables
SQL
15 votes341 views2 answers
How to sort names in alphabetical order in sql
SQL
6 votes156 views1 answer
Postgres get size of database
SQL
0 vote141 views1 answer
Stuff in sql server
SQL
0 vote144 views1 answer
VSCode SQL Server Connection error
SQL
0 vote179 views2 answers
How to truncate all table in mysql workbench
SQL
16 votes172 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote158 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL