Sybase Adaptive Server Anywhere - Page 388

Alphabetical list of functions
370
SUM function [Aggregate]
Returns the total of the specified expression for each group of rows.
SUM ( expression
| DISTINCT column-name )
expression The object to be summed. This is commonly a column name.
DISTINCT column-name This is of limited usefulness, but is included
for completeness.
The following statement returns the value 3749146.
SELECT SUM( salary )
FROM Employee
Rows where the specified expression is NULL are not included.
Returns NULL for a group containing no rows.
♦
SQL/92 SQL/92 compatible.
♦
Sybase Compatible with Adaptive Server Enterprise.
"COUNT function " on page 324
"AVG function " on page 316
TAN function [Numeric]
Returns the tangent of a number.
TAN ( numeric-expression )
numeric-expression An angle, in radians.
The following statement returns the value 0.572561.
SELECT TAN( 0.52 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"COS function" on page 323
"SIN function" on page 365
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also