SQL : count percent of each values

Question

I have a table called Orders, column and values of table.

Column [Order Priority] can have one of 4 values: Critical, High, Medium, Low. Ship_tt can have one of 3 values: Som, Tre, Dung.

I want to calculate percentage 'Som','Tre','Dung' of Critical, High, Medium, Low.

Thanks for your help.

Check out this:- https://stackoverflow.com/questions/770579/how-to-calculate-percentage-with-a-sql-statement — rahul c, Sep 19 '22 at 04:50

score 0 · Answer 1 · answered Sep 19 '22 at 06:15

0

SELECT ORDER_PRIORITY, 100. * COUNT(*) / SUM(COUNT(*)) OVER ()
FROM @T T
GROUP BY ORDER_PRIORITY

answered Sep 19 '22 at 06:15

1 Answers1