Thread: Count Distinct
View Single Post
  #1 (permalink)  
Old August 11th, 2006, 08:28 AM
Jonas Jonas is offline
Authorized User
 
Join Date: Jul 2006
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Count Distinct

Hey all,

I have a query pulling up many different claims and corresponding payments. My question is how to get a count of each different claim ID, not total number of claim ID's. For example:
Claim 1 $500
Claim 2 $600
Claim 1 $700

I want this count to be 2, not 3. 2 different claims (Claim 1 and Claim 2) not total claims. Thanks!

Reply With Quote