Aggregation Functions in Oracle/SQL

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:
https://t.me/techtalkswithnaresh

FOLLOW US :
============
YouTube : https://youtube.com/c/TechTalkwithNaresh

For More details Contact Us:

Email: [email protected]
--------------------------------------------------------------------------------------------------------------------------------------------------------

This video will help them who are in the learning phase of SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL please comment in comment section. Please Like,Share and Subscribe the video.


There are 5 types of Aggregation function.
1. COUNT: Which will count the number of records present in table.
SELECT COUNT(*) FROM emp;

2. MAX: Which will find the Maximum value from the specified column.
SELECT MAX(sal) FROM emp;

3. MIN: Which will find the Minimum value from the specified column.
SELECT MIN(sal) FROM emp;

4. AVG: Which will count the Average of values in specified column.
SELECT AVG(sal) FROM emp;

5. SUM: Which will SUM all the values specified column.
SELECT SUM(sal) FROM emp;

SELECT COUNT(*) COUNT, SUM(sal) SUM, MIN(sal) Minimum, MAX(sal) Maximum, AVG(sal) Average FROM emp;