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 vote201 views1 answer
Mysql grouping functions
SQL
0 vote178 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote190 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
14 votes228 views3 answers
SQL trim
SQL
-1 vote250 views1 answer
Mysql coalesce
SQL
1 vote198 views1 answer
Sql server epoch to datetime
SQL
1 vote213 views2 answers
Mysql extract number from string
SQL
2 votes187 views1 answer
While loop sql
SQL
0 vote192 views1 answer
Oracle archivemode
SQL
2 votes237 views1 answer
Username sql
SQL