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

12.13    How to use avg( ) function

select avg(rainfall) "avg" from rainfall_master

avg

- - -

22,33333

12.14    How to use count( )

function

select     Count(rainfall)     "no.of     records"     from

rainfall-master no,of records

- - -

3

List Functions: In one particular row, various values are stored as morning-price, noon-price, evening-price date wise,

If we want to know the least or greatest value among rows, we can provide syntax as "select date_of_trans "date", greatest(morning_price, noon_price, evening_price) "Gold High Price", least(morning_price,