DB2 graphic  QMF Version 8

MIN. -- Calculate the minimum value

The MIN. column function returns the smallest value in the group of numbers or characters in a specified column. You can apply MIN. to columns of any type.

If MIN. is applied to a CHAR or VARCHAR type column, alphanumeric ordering is used.

QMF ignores null values when searching for the minimum. If all values specified in a column are null, QMF returns no value.

You can use an example element with MIN. to select the minimum years of employment for employees in the Q.STAFF table.

When you run this query:

Q.STAFF | NAME    | DEPT | YEARS |            |
--------+---------+------+-------+------------|
        |         |      | _Y    | P. MIN. _Y |

QMF produces this report:

MIN(YEARS)
----------
         1

Rules for MIN.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004