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 vote143 views1 answer
Sql tabelle erstellen
SQL
3 votes178 views1 answer
Sql datetime as date
SQL
2 votes154 views1 answer
Oracle drop sequence if exists
SQL
0 vote190 views1 answer
Example database query
SQL
0 vote183 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
-1 vote165 views5 answers
Operator in sql
SQL
2 votes154 views1 answer
Sql string_agg
SQL
0 vote179 views1 answer
Isnull in sqlite
SQL
0 vote159 views1 answer
Excel vba import data to sql server
SQL
0 vote152 views1 answer
Sql select column name like from multiple tables
SQL