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

2 votes346 views1 answer
Update with join sql server
SQL
0 vote355 views1 answer
SQL column name Oracle
SQL
2 votes351 views2 answers
Mysql find max value row
SQL
0 vote353 views1 answer
Sql find record cannot cast date
SQL
1 vote329 views1 answer
Lpad function in sql oracle
SQL
10 votes359 views2 answers
Mysql alter add foreign key
SQL
1 vote349 views1 answer
Trim leading zeros in sql
SQL
0 vote334 views2 answers
Csv into data postgres
SQL
0 vote343 views1 answer
Sql tabelle erstellen
SQL
3 votes365 views4 answers
Postgresql change timezone on timestamp without timezone
SQL