Group By and Having

[Lynn_AccessUser]

I have the following code:

SELECT ClassID, COUNT(*) AS Total
FROM dbo.tbl_Claimant
GROUP BY ClassID

The problem is I want to filter out PersonID <> 20 but when I do that I have to put PersonID in the group by and then it groups it by PersonID instead of just ClassID. So instead of getting 10 ClassID with a count I get 100 records with a count.

Any suggestions?

 

[Rich]

Use the Where not group by on PersonID

 

[Lynn_AccessUser]

Sorry . . . do what?

 

[Rich]

Select Where and not GroupBy for PersonID

 

[Lynn_AccessUser]

Got it . . . I was putting the where clause after the group by which is why it never worked and I thought I had to do something else. Thanks