Posted By

Tate on 07/22/08


Versions (?)

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

 / Published in: SQL

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

Report this snippet  

You need to login to post a comment.