How to count SQL rows

Question

SELECT count(*) FROM Stack WHERE Id = 33478 GROUP BY SID

Output:

(No column name)
1
4

For the result; there are two row. How can I return it 2? (count of rows)

Are there any way like below:

Select COUNT(SELECT count(*) FROM Stack WHERE ContentId = 33478 GROUP BY SID) ....

Thanks.

Eugen Rieck · Accepted Answer · 2012-09-06 22:35:30Z

4

You should look at the DISTINCT keyword:

SELECT COUNT(DISTINCT SID) FROM Stack WHERE Id = 33478

answered Sep 6, 2012 at 22:35

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

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

2 Comments

+1... Beat me to it! First time my answer got rejected because it was an exact duplicate of a previous answer...

I didn't even know of this feature - nice!