sql use with to get value counts and percentages

Solutions on MaxInterview for sql use with to get value counts and percentages by the best coders in the world

Search
showing results for - "sql use with to get value counts and percentages"
Maryam
30 Apr 2018
1SELECT event, 
2       count(event) as event_count,
3       count(event) * 100.0 / (select count(*) from event_information) as event_percent
4FROM event_information
5group by event
6
source
similar questions
find lowest number in sqlget records in sql according to month name and countidentify number of rows in sqlhow to find the most occuring in sqlsql only show where count is great than 1to count number of rows in sql tablerow number mssqlcount number of entries including 0s sqlfind number of entries sqlhow to find lowest in sqlsql query to find percentage of null values in a tablehow to count number of rows in sqloracle number to percentagetsql find the value and count of the item that occurs the most in a columncount number of entires by months sqlfind most frequent value in sql columncounting in sqlsql query to get the number of rows in a tablesql select lowest value rowsql and usage amountcalculate percentage in sqlsql count value greater than
queries leading to this page
sql calculate percentagessql count percentagehow to calculate percentage of total in sqlcalculate percentage based on total in sqlfind percentage from total in sqlwhat is number percentage number in sqlsql query to count the percentagesql find count percentagehow to get percentage of records in sqlsql find percentage of totalsql calculate percentage of where query with totalsql use with to get value counts and percentages