How to Find the Percentage of A column

I Have column which has a value for each day for example :

Event Day  Category
10-10-10      1
10-10-10      2
11-10-10      1
11-10-10      2
11-10-10      2
11-10-10      2

I want to do percentage for each Category for each day.

So output :

Event Day  Category   %
10-10-10      1      50
10-10-10      2      50
11-10-10      1      25
11-10-10      2      75

My Query :

Select event_day, Category, count(*) from my_table group by event_day, Category;

How to get the total count for a Day so I can derived the percentage.

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

in mysql 8+ :

Select event_day
       , Category
       , count(*)* 100.0 /sum(count(*)) over (partition by event_day)
from my_table 
group by event_day, Category;

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating