Advanced Search

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

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

You need to login to view comments.