Min, Max Functions Example

This example uses the Orders table to return the lowest and highest freight charges for orders shipped to the United Kingdom.

SELECT Min(Freight) AS [Low Freight], 
Max(Freight)AS [High Freight] 
FROM Orders 
WHERE ShipCountry = 'UK';)