Difference between revisions of "SQL MIN()"

From Recital Documentation Wiki
Jump to: navigation, search
m (MIN() moved to SQL MIN())
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=MIN()=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Returns a minimum value in a SELECT statement
 
Returns a minimum value in a SELECT statement
Line 24: Line 17:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
SELECT MIN(sal) Minimum FROM accounts;
+
SELECT MIN(sal) Minimum FROM accounts
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL|MIN()]]
 
[[Category:SQL|MIN()]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 17:16, 22 December 2009

Purpose

Returns a minimum value in a SELECT statement


Syntax

MIN(<expr>)


See Also

AGGREGATES, AVG(), COUNT(), MAX(), SELECT, SUM()


Description

Returns the minimum value of <expr>. The <expr> can be a numeric or date expression.


Example

SELECT MIN(sal) Minimum FROM accounts


Products

Recital, Recital Server