Return to Snippet

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