Query for displaying the details of those employees whose salary is greater than or equal to the average salary | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Query for displaying the details of those employees whose salary is greater than or equal to the average salary

11th May 2017, 2:08 PM
Akshat Agrawal
Akshat Agrawal - avatar
2 Answers
+ 9
You can put a tick on Mr Programmer's answer
11th May 2017, 4:23 PM
Vaibhav Sharma
Vaibhav Sharma - avatar
+ 3
SELECT * FROM EMPLOYEES WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);
11th May 2017, 3:33 PM
MR Programmer
MR Programmer - avatar