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 vote359 views3 answers
Average salary in sql
SQL
0 vote328 views1 answer
Declaring variables in pl sql
SQL
0 vote356 views1 answer
Pl/ sql change currency
SQL
0 vote350 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote365 views1 answer
Sql into vs insert into
SQL
0 vote385 views1 answer
Drop database using terminal postgres
SQL
1 vote334 views1 answer
Foreign key in oracle sql developer
SQL
0 vote374 views1 answer
Oracle array
SQL
0 vote375 views1 answer
Full outer join in mariadb mysql
SQL
0 vote358 views1 answer
How to use select union and loop
SQL