Advanced Search

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





SQL