Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Buy a domain name - Register cheap domain names from $0.99 - Namecheap

Scalable Hosting That Grows With You

Secure & Reliable Web Hosting, Free Domain, Free SSL, 1-Click WordPress Install, Expert 24/7 Support

Semrush - keyword research tool

Boost your online presence with premium web hosting and servers

Disclosure: My content contains affiliate links.

39,870 questions

51,793 answers

573 users

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 376 views
2 answers 360 views
2 answers 341 views
1 answer 304 views
1 answer 267 views
1 answer 243 views
243 views asked Oct 4, 2015 by avibootz
...