SQL functions tutorial

Home

Add to Favorites

Ebooks Directory

News

SQL & PL/SQL Resources

Home

SQL , PL/SQL Article

SQL Tutorial

Books

SQL Questions

SQL Code

PL/SQL Tutorial

SQL Reference

SQL Tutorial

SQL FUNCTIONS

* AVG
* COUNT
* MAX
* MIN
* SUM

syntax :

SELECT function type(column_name)
FROM table_name

Example : 11

SELECT AVG(Age) FROM Employee;

RESULT:

-----------------
| AVG(Age) |
-----------------
| 52.33 |
----------------

Example 12:

SELECT COUNT(Age) FROM Employee;

RESULT:

--------------------
| COUNT(Age)|
--------------------
| 3 |
-------------------

Example 13:

SELECT MAX(Age) FROM Employee;

RESULT:

--------------------
| MAX(Age) |
--------------------
| 65 |
-------------------

Example 14:

SELECT MIN(Age) FROM Employee;

RESULT

--------------------
| MIN (Age) |
--------------------
| 38 |
-------------------

Example 15:

SELECT SUM(Age) FROM Employee;

RESULT

--------------------
| SUM(Age) |
--------------------
| 157 |
-------------------

Go To Index