Page History

This document details Aqua Data Studio's Excel SQL syntax and functions. Supported functions include Aggregate Functions, Numeric Functions, String Functions, Time and Date Functions.

Aggregate Functions New in 17.0

Numeric Functions New in 17.0

String Functions New in 17.0

Time and Date Functions New in 17.0

More Functions New in 17.0

Aggregate Functions

AVG

Returns the average (mean) value. If no rows are selected, the result is NULL. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.

...

SELECT  AVG(Salary)  FROM  Employee

Back to top

COUNT

Returns the count of all rows, or of non-null values.

...