Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

AVG

The AVG() Function return the average value of a numeric column.
The basic syntax is as follows:
SELECT AVG(Column_Name) FROM Table_Name
Syntax For SQL:
SELECT AVG(Salary) FROM Employee
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

After Execute: 
AVG(Salary)
53800.00

No comments:

Post a Comment