Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR 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);
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #sql #select #record #exists
ADD COMMENT
Topic
Name
7+4 =