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 vote185 views1 answer
Object Information
SQL
0 vote185 views1 answer
Wordpress sql change site url
SQL
1 vote197 views1 answer
Sqlite update from another table
SQL
1 vote185 views1 answer
Real world example of nosql
SQL
2 votes197 views2 answers
Created at and updated at in mysql
SQL
0 vote189 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote199 views1 answer
How to to get time in sql
SQL
-1 vote214 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote192 views1 answer
First Step in installing SQL workbench
SQL
17 votes183 views2 answers
How to assign date field for table in mysql
SQL