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

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

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

- - -

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,