/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

7 votes201 views2 answers
Oracle foreign key reference table
SQL
4 votes213 views2 answers
Show all database inside postgresql
SQL
0 vote218 views1 answer
Vbscript connect mssql
SQL
25 votes225 views1 answer
How to update an attribute in MySQL
SQL
11 votes223 views5 answers
Sql server reset identity
SQL
4 votes208 views1 answer
Mysql copy table with new name
SQL
11 votes209 views3 answers
Change column name sql server management studio
SQL
0 vote195 views1 answer
What alter does in db
SQL
0 vote207 views1 answer
Implizite joins sql
SQL
0 vote199 views1 answer
Jooq replace
SQL