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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » SQL functions (E-O)

 

GREATER function [Miscellaneous]

Returns the greater of two parameter values.

Syntax
GREATER( expression-1, expression-2 )
Parameters
  • expression-1   The first parameter value to be compared.

  • expression-2   The second parameter value to be compared.

Returns

ANY

Remarks

If the parameters are equal, the first is returned.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value 10.

SELECT GREATER( 10, 5 ) FROM dummy;