Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / Consider the following Employee table. Which of the following statements give the list of

Consider the following Employee table. Which of the following statements give the list of

Consider the following Employee table.

Which of the following statements give the list of departments having average salary greater than 20000 from employee table?

(a)SELECT Dept_No,AVG(Salary) FROM Employee ORDER BY Dept_No HAVING AVG(Salary)>20000
(b)SELECT Dept_No,AVG(Salary) FROM Employee HAVING AVG(Salary)>20000
(c)SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No HAVING AVG(Salary)>20000
(d)SELECT Dept_No,AVG(Salary) FROM Employee WHERE AVG(Salary)>20000
(e)SELECT Dept_No,AVG(Salary) FROM Employee GROUP BY Dept_No WHERE AVG(Salary)>20000.

Dec 29 2017 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions