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

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (E-O)


MIN function [Aggregate]

Returns the minimum expression value found in each group of rows.

Syntax 1
MIN( expression | DISTINCT expression )
  • expression   The expression for which the minimum value is to be calculated. This is commonly a column name.

  • DISTINCT expression   Returns the same as MIN( expression ), and is included for completeness.


The same data type as the argument.


Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.

See also
Standards and compatibility
  • SQL/2003   Core feature.


The following statement returns the value 24903.000, representing the minimum salary in the Employees table.

SELECT MIN( Salary )
FROM Employees;