Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
This function is the same as the ESTIMATE function, except that it always looks in the frequency table.
[, 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;