FlipKart Offer

Translate to Tamil

Amazon Best Offer

AliExpress Offers

Online Income

Wednesday, 20 April 2011

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 

 Share This Post


Smilely

Services

© 2014