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 vote141 views1 answer
Sql select min row
SQL
1 vote137 views1 answer
Sqlalchemy order by descending
SQL
1 vote135 views1 answer
Mysql text to decimal
SQL
0 vote150 views1 answer
Sql server rtrim everything after character
SQL
4 votes141 views4 answers
Check constraint in ms sql
SQL
25 votes148 views6 answers
How to change column name in mysql
SQL
0 vote169 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote161 views2 answers
Clauses in mysql
SQL
0 vote140 views1 answer
Delete duplicate rows
SQL
1 vote137 views1 answer
Alter add syntax
SQL