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 vote168 views1 answer
Create new schema mysql
SQL
-1 vote210 views2 answers
Sql search all tables for attributes
SQL
1 vote167 views1 answer
Get url of cpanel database hostname
SQL
6 votes194 views1 answer
To count number of rows in SQL table
SQL
0 vote164 views2 answers
Clear window pl sql
SQL
0 vote174 views1 answer
Linebreak sql
SQL
0 vote197 views1 answer
Space not removing from column in sql
SQL
7 votes260 views1 answer
Oracle alter sequence restart start with
SQL
0 vote167 views1 answer
Oarcale list objects
SQL
0 vote176 views1 answer
Drop procedure sql
SQL