SQL Max() and Min()

The MAX() function returns the largest value of the selected column.

Syntax 


        SELECT MAX(column_name) FROM table_name

 The "custmast" table

custcode	custname	city	qty	rate
1	Siva	Srivilliputtur	50	70
2	Bala	Sivakasi	30	56
3	Kanna	Madurai	100	200
4	Vijay	Chennai	30	30
5	Kodee	Sandnes	60	80
5	Kodee	Srivilliputtur	60	30

Example : 

SELECT MAX(Qty) as MaxQty FROM custmast

MaxQty

100