Count(*) "no.of records" from rainfall_master" will produce the required values as maximum rainfall, minimum rainfall, average rainfall, no,of records exist etc, Assume three records rainfall as 23,7, 31,3, and
12,0
12.11 How to use max( )
function
select max(rainfall) "max" from rainfall_master
max
- - -
31,3
12.12 How to use min( ) function
select min(rainfall) "min" from rainfall_master
min
- - -
32,0