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