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 vote106 views1 answer
Sql change column in existing table
SQL
24 votes101 views2 answers
Alter table delete column
SQL
5 votes128 views2 answers
Mysql create database charset utf8mb4
SQL
2 votes105 views2 answers
Sqlalchemy filter or
SQL
0 vote115 views1 answer
Joins vs includes
SQL
-1 vote106 views3 answers
Create temp table in sql
SQL
0 vote134 views1 answer
Prisma transaction
SQL
0 vote123 views1 answer
Pgadmin save data greyed out
SQL
0 vote118 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote136 views1 answer
Sql to excel pgadmin
SQL