MAX

Returns the largest value of the field in the resultset/group.

 

Example:

With the sample data set:

 

Field1

Field2

Field3

23

10

17

17

10

9

5

12

15

 

 

SELECT MAX(Field1) returns 23.