Difference between revisions of "Min"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
(jrfconvert import)
Line 4: Line 4:
 
====min====
 
====min====
  
Gets the minimum numeric value of a specific column.
+
Gets the minimum numeric value of a set of expressions. The values of all parameters must be convertible to numbers.
  
 
'''Syntax'''
 
'''Syntax'''
  
min(columnName)
+
min(''exp1, exp2, exp3,'' …)
  
 
'''Arguments'''
 
'''Arguments'''
  
columnName: Is the name of a column in the data table.
+
''exp''i: Is an expression of any type
  
 
'''Return type'''
 
'''Return type'''
Line 20: Line 20:
 
'''Examples'''
 
'''Examples'''
  
//get the minimum score
+
number a = min(1, 2, "3", 4 + 1, 5);
  
number minScore = min(Score) where (true);
+
print(a);
 +
 
 +
//a = 1
  
 
'''Availability'''
 
'''Availability'''
Line 28: Line 30:
 
Version 4.8
 
Version 4.8
 
__NOTOC__
 
__NOTOC__
<!-- imported from file: 761.htm-->
+
<!-- imported from file: 569.htm-->

Revision as of 09:50, 7 March 2011



min

Gets the minimum numeric value of a set of expressions. The values of all parameters must be convertible to numbers.

Syntax

min(exp1, exp2, exp3, …)

Arguments

expi: Is an expression of any type

Return type

number

Examples

number a = min(1, 2, "3", 4 + 1, 5);

print(a);

//a = 1

Availability

Version 4.8