forum

Home / DeveloperSection / Forums / How to get multiple count in sql

How to get multiple count in sql

benjamin richards208912-Feb-2013

Hi MindStickians!

I have a table in my database in which I have three columns:

[Article_ID] INT IDENTITY PRIMARY KEY,
[Article_Title] NVARCHAR(Max),
[Article_Rating] INT

Now the user can enter a maximum number 5 in rating and minimum 1 now I have to query that how many times users entered 1, how many times 2, how many times

3, how many times 4 and how many times 5

Thanks in advance.


Updated on 12-Feb-2013

Can you answer this question?


Answer

1 Answers

Liked By