/SQL/Sql select where more than one record exists

Sql select where more than one record exists

SELECT *
FROM article
WHERE article_title IN (SELECT *
                        FROM (SELECT article_title
                              FROM article
                              GROUP BY article_title
                              HAVING COUNT(article_title) > 1)
                        AS a);

Source: dba.stackexchange.com

Similar codes

15 votes262 views2 answers
How to drop database name in postgresql
SQL
0 vote285 views1 answer
Pl/ sql change currency
SQL
5 votes328 views2 answers
How to ascending order in sql
SQL
0 vote295 views1 answer
How to make case insensitive in sql
SQL
0 vote279 views1 answer
Sqlplus change user
SQL
0 vote272 views1 answer
Grouping by email domain mysql
SQL
0 vote253 views1 answer
Sql random decimal
SQL
0 vote277 views1 answer
How to output a different column name in mysql
SQL
0 vote269 views1 answer
Sql select first and last record of each group
SQL
3 votes290 views2 answers
Sql not contains
SQL