+ 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 ответов
+ 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