SELECT COUNT(*) SQL SERVER

Question

I have this:

SELECT AssignmentID
FROM ProblemView
GROUP BY AssignmentID

which returns 32 rows. But really what I want is the number 32. If I do this:

SELECT COUNT(*)
FROM lru.ProblemView
GROUP BY AssignmentID

I still get 32 rows, and the column is merely the count of the number of Assignments per problem.

I just need the number 32.

D'Arcy Rittich · Accepted Answer · 2011-01-02 00:47:31Z

18

SELECT count(distinct AssignmentID) 
FROM ProblemView

answered Jan 2, 2011 at 0:47

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sheesh. When am I ever going to learn SQL Server? Thank you very much!