SQL function examples
SQL Statement | Syntax | Example Statement | Example Result or Description |
HAVING |
SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value |
Use HAVING to specify conditions when using SQL aggregate functions. (Use instead of WHERE for aggregate functions.) |
|
AVG() |
SELECT AVG(column_name) FROM table_name; |
Use AVG() to calculate the average value of the non-null records in the specified column. |
|
COUNT() |
SELECT COUNT(column_name) FROM table_name; |
select ApplicationName as Name, count(*) as Count from Event where WhenOccurred >= DateFunc('now', '-30') and EventType='Cloud.Saas.Application.AppLaunch' group by name order by count desc |
COUNT (Column_name) returns the number of non-null values in the specified column. COUNT (*) returns the number of records in a table. COUNT (Distinct column_name) returns the number of distinct values in the specified column. |
MAX() MIN() |
SELECT MAX(column_name)FROM table_name; SELECT MIN(column_name)FROM table_name; |
Use MAX() to return the maximum value of all values in the group. use MIN() to return the minimum, non-null value of all values in the group. The results include null values only if there are no non-null values. |