Horje
sql use with to get value counts and percentages Code Example
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



Sql

Related
sql server remove 0 from left Code Example sql server remove 0 from left Code Example
how to get last element sql Code Example how to get last element sql Code Example
soql update query Code Example soql update query Code Example
postegresql update to null Code Example postegresql update to null Code Example
MySQL INSERT IGNORE Statement Code Example MySQL INSERT IGNORE Statement Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje