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

50 votes365 views6 answers
Sql duplicate rows
SQL
0 vote277 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote290 views1 answer
Set a default value for a column in sqlite
SQL
3 votes311 views1 answer
Oracle transaction commit rollback example
SQL
4 votes307 views1 answer
Id increment ms sql server
SQL
0 vote314 views1 answer
Sql date time query find
SQL
0 vote296 views2 answers
Mysql create table if not exists
SQL
0 vote269 views1 answer
How to install Firebird
SQL
9 votes278 views4 answers
Mysql show table fields
SQL
3 votes306 views3 answers
Restart mysql mac
SQL