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. Possible values for this parameter are: =, >, <, >= , <=, <>, !=, !<, and !>. The default is =.
If value is NULL then the relation strings = and != are interpreted as the IS NULL and IS NOT NULL conditions, respectively.
SQL/2003 Vendor extension.
The following statement returns NULL.
SELECT DISTINCT EXPERIENCE_ESTIMATE( EmployeeID, 200, '>' ) FROM Employees;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|