/SQL/Sql use with to get value counts and percentages

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

Source: stackoverflow.com

Similar codes

11 votes110 views2 answers
Turn off safe mode mysql
SQL
0 vote106 views1 answer
Object of class mysqli_result could not be converted to string
SQL
31 votes111 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote109 views1 answer
Html css mobile menu arrow dropdown
SQL
3 votes100 views1 answer
Two selects in one query
SQL
0 vote98 views1 answer
Oracle list dblink
SQL
3 votes118 views2 answers
How to View column names of a table in SQL
SQL
3 votes112 views3 answers
Raw select laravel
SQL
0 vote95 views1 answer
Clone table structure mysql
SQL
0 vote130 views1 answer
How much space does sql server take per row
SQL