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 vote258 views1 answer
Soql last week
SQL
0 vote272 views2 answers
Reseed sql identity
SQL
2 votes272 views2 answers
Convert_tz mysql
SQL
0 vote253 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote271 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote283 views1 answer
Date datatype in livesql
SQL
0 vote240 views1 answer
Count column of tables psql
SQL
1 vote246 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote258 views1 answer
Order by with where clause in mysql
SQL
6 votes257 views2 answers
WHERE value IS sql
SQL