aggregate function

The following are the most commonly used SQL aggregate functions:
* AVG – calculates the average of a set of values.
* COUNT – counts rows in a specified table or view.
* MIN – gets the minimum value in a set of values.
* MAX – gets the maximum value in a set of values.
* SUM – calculates the sum of values.
<pre><code>
select avg(emp_no), count(*), min(emp_no), max(emp_no), sum(emp_no) from titles;
</code></pre>
Home