How to use SQL AVG() Function in MySQL

2 Answers

0 votes
SELECT AVG(Salary) AS AverageSalary 
FROM workers

 



answered Sep 28, 2015 by avibootz
edited Sep 29, 2015 by avibootz
0 votes
SELECT * 
FROM workers 
WHERE Salary > (SELECT AVG(Salary) FROM workers)

 



answered Sep 29, 2015 by avibootz

Related questions

3 answers 409 views
2 answers 396 views
2 answers 382 views
1 answer 332 views
1 answer 291 views
1 answer 266 views
266 views asked Oct 4, 2015 by avibootz
...