/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

14 votes113 views2 answers
Oracle export trigger ddl
SQL
0 vote106 views1 answer
Conda install pymysql "windows"
SQL
2 votes150 views3 answers
Mysql cheat sheet
SQL
2 votes107 views2 answers
Postgres timestamp to datetime
SQL
1 vote102 views1 answer
Postgres check for foreign key
SQL
1 vote106 views1 answer
Declare variables sql
SQL
1 vote119 views1 answer
Drop primary key oracle
SQL
23 votes111 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote111 views1 answer
How to check common records in 2 table
SQL
0 vote100 views1 answer
Order by ip address sql
SQL