This article provides an example to display highest item price of item table using max() function.
Selectmax(itemprice) from item; Output: MAX(ITEMPRICE) -------------- 700