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 vote247 views1 answer
Multiple replace value mssql
SQL
0 vote130 views1 answer
Get sum sqlite android
SQL
1 vote154 views1 answer
Myql find duplicates
SQL
1 vote156 views1 answer
Sqlite create index
SQL
0 vote144 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote151 views1 answer
Sql server get users
SQL
1 vote132 views1 answer
Sql select all from one table and one column from another
SQL
0 vote138 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
8 votes162 views3 answers
Find table for column name in sql
SQL
5 votes144 views1 answer
Commentaire table oracle
SQL