We have a Result table with fields called QuestionID and Answer.
How can I get a query result where the result is group by the answer and its
percentage ?
Thanks.

For ex: Results table:
QuestionID    Answer
1                    aaa
1                    aaa
1                    ddd
2                    yyyy

I want the result of the query for QuestionID = 1 to look like:
aaa    2    66.6666
ddd    1    33.3333

CREATE PROCEDURE GetResults
@QuestionID numeric(9)
AS

SELECT     Answer, COUNT(Answer) AS votes
FROM         Results
WHERE     (Question = @QuestionID)
GROUP BY Answer
GO

Hello, fniles

Use something like this:

SELECT Answer,
    COUNT(*) AS votes,
    100. * COUNT(*) / (
        SELECT COUNT(*)
        FROM Results
        WHERE QuestionID = @QuestionID
    ) as Percentage
FROM Results
WHERE QuestionID = @QuestionID
GROUP BY Answer

Razvan

Thanks ! That works.

Show quoteHide quote

store image
DB design question.
Building View Dynamically .. Need Help!
Updating a view ... (SQL Sever 2000)
Update Query Returns -1 Represents ?