Users Pricing

forum

Home Forums How to get multiple count in sql – MindStick

How to get multiple count in sql

benjamin richards 2526 12 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.


1 Answers

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md