April 2008
Intermediate to advanced
566 pages
21h 55m
English
LEAST()
LEAST(value,value, ...)
Use this function to compare two or more values and return the
smallest value. In an INTEGER datatype context, all
values are treated as integers for comparison. In a
REAL data type context, all values are treated as
REAL values for comparison. If any parameter
contains a case-sensitive string (i.e., with a
BINARY keyword), all values are compared as
case-sensitive strings. Here is an example:
SELECT LEAST(col1, col2, col3);
Read now
Unlock full access