.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

What Are Group Functions

Q

What Are Group Functions? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements

✍: FYIcenter.com

A

Group functions are functions applied to a group of rows. Examples of group functions are:

  • COUNT(*) - Returns the number of rows in the group.
  • MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group.
  • MAX(exp) - Returns the maximum value of the expression evaluated on each row of the group.
  • AVG(exp) - Returns the average value of the expression evaluated on each row of the group.

2007-04-20, 4931👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML