Prev Up Next
__min Home __max_notnull

Name

__max — Returns maximum value among all its arguments.

Synopsis

any __max ( arg1 any ,
arg2 any ,
... ,
argN any );

Description

The function returns the maximum value among all values in all its arguments.

Parameters

argI

Values which can be with type float, integer etc.

Examples

Example24.192.

Example 1 

SQL> select __max(12, 2.34, 5, 20.5);
__max
VARCHAR
_______________________________________________________________________________

20.5

1 Rows. -- 16 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://mygraph2.com>, 9 (or less) triples -- done
No. of rows in result: 1

SQL> SPARQL SELECT ?s (bif:__max(?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        6
http://mygraph2.com/pricing/#QVal2        4
http://mygraph2.com/pricing/#QVal1        9

No. of rows in result: 3

See Also

__min()

__min_notnull()

__max_notnull()

Prev Up Next
__min Home __max_notnull