Difference between revisions of "SQL MIN()"

Latest revision as of 06:37, 23 February 2021

Returns a minimum value in a SELECT statement

MIN(<expr1> [, <expr2> [, ...]])

Returns the minimum value of <expr1> or the list of expressions (list supported from v6.0).

The expressions can be of the following data types:

open database southwind
select min(orderdate,requireddate,shippeddate) from orders
select min(companyname) from customers

@@ Line 1: / Line 1: @@
 ==Purpose==
 Returns a minimum value in a SELECT statement
 ==Syntax==
-MIN(<expr>)
+MIN(<expr1> [, <expr2> [, ...]])
 ==See Also==
 [[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[COUNT()]], [[SQL MAX()|MAX()]], [[SQL SELECT|SELECT]], [[SUM()]]
 ==Description==
-Returns the minimum value of <expr>.  The <expr> can be a numeric or date expression.
+Returns the minimum value of <expr1> or the list of expressions (list supported from v6.0).
+The expressions can be of the following data types:
+* Numeric
+* Date
+* Character (from v6.0)
+* Currency (from v6.0)
+* Datetime (from v6.0)
 ==Example==
 <code lang="recital">
-SELECT MIN(sal) Minimum FROM accounts
+open database southwind
+select min(orderdate,requireddate,shippeddate) from orders
+select min(companyname) from customers
 </code>
-==Products==
-Recital, Recital Server
 [[Category:Documentation]]
 [[Category:SQL|MIN()]]
 [[Category:Functions]]
+[[Category:SQL Functions]]
+[[Category:Lianja v6.0]]