Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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