What Are Group Functions

What Are Group Functions? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY

✍: FYIcenter.com

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-05-11, 5208👍, 0💬

Popular Posts:

What would you use to compare two String variables - the operator == or the method equals()? You can...

How To Specify Two Background Images on a Page? - CSS Tutorials - Page Layout and Background Image D...

What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...

What is the sequence of UML diagrams in project? First let me say some fact about this question, you...

How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...