/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

0 vote149 views1 answer
How to access to mysql without root
SQL
24 votes144 views6 answers
Replace mysql
SQL
0 vote178 views1 answer
Sql filter rows with condition
SQL
5 votes143 views1 answer
Sort order on two columns sql
SQL
1 vote136 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote132 views1 answer
How to delete a record from sqlite in android
SQL
0 vote131 views1 answer
Close sql query vb.net
SQL
4 votes145 views3 answers
Count with where
SQL
1 vote149 views1 answer
Sqlserver create table from select
SQL
2 votes153 views1 answer
Oracle percentage
SQL