Sybase Adaptive Server Anywhere - Page 356

Alphabetical list of functions
338
♦
Sybase Compatible with Adaptive Server Enterprise.
EXPERIENCE_ESTIMATE function [Miscellaneous]
This function is the same as the ESTIMATE function, except that it always
looks in the frequency table.
EXPERIENCE_ESTIMATE ( column-name [ , value [, relation-string ] ] )
column-name The name of the column that is being investigated.
value The value to which the column is compared.
relation-string The comparison operator used for the comparison,
enclosed in single quotes; the default is ’=’.
The following statement returns NULL.
SELECT DISTINCT EXPERIENCE_ESTIMATE( emp_id, 200, ’>’ )
FROM employee
♦ SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
"ESTIMATE function" on page 334
FLOOR function [Numeric]
Returns the floor of (largest integer not greater than) a number.
FLOOR ( numeric-expression )
numeric- expression The number, usually a float.
Value FLOOR (Value)
123 123
123.45 123
-123.45 -124
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"CEILING function" on page 318
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also