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

7 votes322 views1 answer
Safe update mysql
SQL
0 vote347 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
2 votes320 views1 answer
Copy all values of a column to another column in sql in same table
SQL
10 votes323 views4 answers
Sql pagination
SQL
0 vote344 views1 answer
How to find the most occuring in SQL
SQL
0 vote310 views1 answer
Mysql regex exact match
SQL
2 votes343 views1 answer
Ifnull postgres
SQL
0 vote552 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote383 views1 answer
Site:av.ru "files"
SQL
0 vote301 views1 answer
Dump only schema
SQL