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 vote336 views1 answer
Oracle step procedure
SQL
9 votes365 views3 answers
Where clause sql
SQL
0 vote352 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote343 views1 answer
How change the field place in mysql
SQL
0 vote315 views1 answer
Mod function example
SQL
0 vote300 views1 answer
Oracle list all stored procedures
SQL
0 vote331 views1 answer
Selecting Data in SQL - Select Data
SQL
1 vote318 views1 answer
Funzioni plsql
SQL
0 vote317 views1 answer
Mysql Error Code: 1005
SQL
9 votes346 views6 answers
Replace sql
SQL