Oracle SQL

What is group function in Oracle SQL?

Group Function in SQL
Written by shohal

Group Function

Group functions are built-in SQL functions that operate on groups of rows and return one value for the entire group. These functions are: COUNT, MAX, MIN, AVG, SUM, DISTINCT. SQL COUNT (): This function returns the number of rows in the table that satisfies the condition specified in the WHERE condition.

Example :

Below The Related Topic Link:

Link (Character-Manipulative Functions) : https://techtweet.xyz/2021/12/11/character-manipulative-functions/

Link (Single Row Functions) : https://techtweet.xyz/2021/12/06/single-row-functions/

Link (What is procedure and function in PL/SQL?) : https://techtweet.xyz/2021/10/10/what-is-procedure-and-function-in-pl-sql-2/

About the author

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment