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 vote194 views1 answer
Join creating duplicate columns sqllite
SQL
-1 vote236 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
-1 vote176 views1 answer
Mysql if example
SQL
0 vote211 views1 answer
Sql server update top n records
SQL
5 votes211 views2 answers
Ranking functions in sql
SQL
0 vote228 views1 answer
Sql select sum group by id laravel join
SQL
0 vote212 views1 answer
Select a row include list of array with join table SQL
SQL
10 votes281 views1 answer
Oracle all_dependencies
SQL
0 vote202 views1 answer
Mysql date time string format python
SQL
0 vote235 views1 answer
Mysql where in maintain order
SQL