The MAX and MIN functions
You can combine aggregate functions in the same SELECT
statement. For example, you can include both the MAX and
the MIN functions in the select list, as the following
query shows.
Figure 1. Query
SELECT MAX (ship_charge), MIN (ship_charge) FROM orders;The query finds and displays both the highest and lowest ship_charge in
the orders table.
Figure 2. Query result
(max) (min)
$25.20 $5.00