SQL

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);

sql select in where clause for when more than one records exists

SELECT *
FROM tableName
WHERE columnName IN (SELECT *
                        FROM (SELECT columnName
                              FROM tableName
                              GROUP BY columnName
                              HAVING COUNT(columnName) > 1)
                        AS someLabel);