Sybase Adaptive Server Anywhere - Page 334

Alphabetical list of functions
316
SELECT ATAN2( 0.52, 060 )
♦ SQL/92 Vendor extension.
♦
Sybase ATN2 is compatible with Adaptive Server Enterprise.
ATAN2 is not supported by Adaptive Server Enterprise.
"ACOS function" on page 313
"ASIN function" on page 314
"ATAN function" on page 315
"TAN function" on page 370
AVG function [Aggregate]
Computes the average, for a set of rows, of a numeric-expression or of a set
unique values.
AVG ( numeric-expression | DISTINCT column-name )
numeric-expression The value whose average is calculated over a set of
rows.
DISTINCT column-name Computes the average of the unique values in
column-name. This is of limited usefulness, but is included for completeness.
The following statement returns the value
49988.6.
SELECT AVG( salary ) FROM employee
This average does not include rows where the numeric expression is the
NULL value. Returns the NULL value for a group containing no rows.
♦
SQL/92 SQL/92 compatible.
♦
Sybase Compatible with Adaptive Server Enterprise.
"SUM function" on page 370
"COUNT function " on page 324
BYTE_LENGTH function [String]
Returns the number of bytes in a string.
BYTE_LENGTH ( string-expression )
string-expression The string whose length is to be calculated.
The following statement returns the value
12.
SELECT BYTE_LENGTH( ’Test Message’ )
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples