SQL AVG() Function


SQL AVG() Function

The AVG() function returns the average value of a numeric column.

Syntax

SELECT AVG(column_name) FROM table_name

Example

student Table

sidnamefee
11211Ashwani200
11212Sachin400
11213Deepak600
11214Sanjay800
SELECT AVG(fee) FROM student 
Output
500

Share this article on