Scribd
Upload
15 views4 pages

Database Admin: Aggregate Functions Guide

Uploaded by

bob.ilukhor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views4 pages

Database Admin: Aggregate Functions Guide

Uploaded by

bob.ilukhor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Lecturer : Damien Kettle Database Administration

Tutorial 3 – Aggregate Functions (AVG, COUNT, MAX, SUM )


Aggregate Functions perform a calculation on a set of values and return for a single value.

AVG
To return the Average Age of the Members in our table write the following select statement and
execute.
Lecturer : Damien Kettle Database Administration

COUNT
To return the number of records we have in our member table write the following select statement
and execute.
Lecturer : Damien Kettle Database Administration

MAX
To return the maximum age from the Members table write the following select statement and
execute.
Lecturer : Damien Kettle Database Administration

SUM
To get the sum of all ages write the following select statement and execute.

You might also like