group function in oracle sql (group functions)
GROUP FUNCTION:
GROUP FUNCTION OPERATE SET OF ROWS AND GIVE ONE RESULT PER GROUP.
GROUP FUNCTIONS SYNTAX:
SELECT GROUP_FUNCTION(COLUMN), ...
FROM TABLE
[WHERE CONDITION]
[GROUP BY COLUMN];
GROUP FUNCTIONS:
1. SUM
2. MAX
3. MIN
4. AVG
5. COUNT
EXAMPLE QUERY:
SELECT SUM(SALARY), MAX(SALARY), MIN(SALARY), AVG(SALARY), COUNT(*)
FROM EMPLOYEES;
SELECT DEPARTMENT_ID, SUM(SALARY), MAX(SALARY), MIN(SALARY), AVG(SALARY), COUNT(*)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID;
Retrieve Data Using Select Statement
• Retrieve Data Using Select Statement
Data Sorting and Comparison Operators
• Data Sorting and Comparison Operators
How to Oracle Database Backup and Restore
• How to Oracle Database Backup and Restore