GREATEST(value1,value2,...) returns the largest (maximum-valued) argument within two or more arguments : GREATEST : Comparison Functions Operators MySQL TUTORIALS

MySQL TUTORIALS » Comparison Functions Operators » GREATEST »

GREATEST(value1,value2,...) returns the largest (maximum-valued) argument within two or more arguments


mysql>
mysql>
mysql>
mysql> SELECT GREATEST(2,0);
+---------------+
| GREATEST(2,0) |
+---------------+
|             2 |
+---------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

GREATEST(value1,value2,...) returns NULL if any argument is NULL.
SELECT GREATEST(3.0,3.0,5.0,7.0);
SELECT GREATEST('B','A','C');
Use GREATEST(value1,value2,...) function with column data
GREATEST(@id1, @id2, @id3, @id4, @id5)

MySQL TUTORIALS

Comparison Functions Operators
» GREATEST

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

GREATEST(value1,value2,...) returns the largest (maximum-valued) argument within two or more arguments : GREATEST : Comparison Functions Operators MySQL TUTORIALS

MySQL TUTORIALS » Comparison Functions Operators » GREATEST »

GREATEST(value1,value2,...) returns the largest (maximum-valued) argument within two or more arguments

Leave a Comment / Note

MySQL TUTORIALS