Select rows where there is more than one occurance of a value (opposite of SELECT DISTINCT)

Revision: 7407

at July 22, 2008 13:37 by Tate

Initial Code

SELECT dbo_tblContributorCA.CCA_Contributor_No, Count(dbo_tblContributorCA.CCA_Contributor_No) AS CountOfCCA_Contributor_No
FROM dbo_tblContributorCA
GROUP BY dbo_tblContributorCA.CCA_Contributor_No
HAVING (((Count(dbo_tblContributorCA.CCA_Contributor_No))>1));

Initial URL

Initial Description

Initial Title

Select rows where there is more than one occurance of a value (opposite of SELECT DISTINCT)

Initial Tags

Initial Language

SQL

Choose a language for easy browsing: