Answers for "sql calculate percentage of where query with total"

SQL
0

calculate percentage in sql

SELECT SUM(MARKS)*100/COUNT(MARKS) FROM STUDENT_MARKS
Posted by: Guest on June-04-2021
0

sql use with to get value counts and percentages

SELECT event, 
       count(event) as event_count,
       count(event) * 100.0 / (select count(*) from event_information) as event_percent
FROM event_information
group by event
Posted by: Guest on April-21-2021

Code answers related to "sql calculate percentage of where query with total"

Code answers related to "SQL"

Browse Popular Code Answers by Language