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

1 vote126 views1 answer
Grab all records from one table to another oracle sql
SQL
10 votes117 views3 answers
Sql limit results
SQL
0 vote125 views2 answers
Drop check constraint in ms sql
SQL
0 vote196 views1 answer
Sql delete row from table where id
SQL
1 vote149 views2 answers
Full join
SQL
-1 vote128 views1 answer
Partial search in sql
SQL
0 vote153 views1 answer
Character count sql
SQL
1 vote86 views1 answer
Oracle character set
SQL
0 vote135 views3 answers
Drop multiple columns in sql
SQL
0 vote158 views1 answer
Sql create and grant user access to database
SQL