Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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. 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.

• ESTIMATE function [Miscellaneous]

• SQL/2003    Vendor extension.

The following statement returns NULL.

SELECT DISTINCT EXPERIENCE_ESTIMATE( EmployeeID, 200, '>' )
FROM Employees;