Name
__min — Returns minimum value among all its arguments.
Synopsis
any
__min
(
|
arg1 any , |
arg2 any , | |
... , | |
argN
any
) ; |
Description
The function returns the minimum value among all values in all its arguments.
Parameters
argI
Values which can be with type float, integer etc.
Examples
Example 24.191.
Example 1
SQL> select __min(12, 2.34, 5, 20); __min VARCHAR _______________________________________________________________________________ 2.34 1 Rows. -- 32 msec.
Example 2
SQL> SPARQL INSERT INTO GRAPH <http://mygraph2.com> { <http://mygraph2.com/pricing/#QVal1> <price1> 1 ; <price2> 9 ; <price3> 5 . <http://mygraph2.com/pricing/#QVal2> <price1> 3 ; <price2> 1 ; <price3> 4 . <http://mygraph2.com/pricing/#QVal3> <price1> 6 ; <price2> 2 ; <price3> 2 . }; Insert into <http://mygraph.com>, 9 (or less) triples -- done No. of rows in result: 1 SQL> SPARQL SELECT ?s (bif:__min(?pr1, ?pr2, ?pr3)) FROM <http://mygraph2.com> WHERE { ?s <price1> ?pr1 ; <price2> ?pr2 ; <price3> ?pr3 }; Query result: s callret-1 VARCHAR VARCHAR _______________________________________________ http://mygraph2.com/pricing/#QVal3 2 http://mygraph2.com/pricing/#QVal2 1 http://mygraph2.com/pricing/#QVal1 1 No. of rows in result: 3