Service

Chat Now

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.

Johnson 29-Dec-2017

Answer (Solved)

question Get solution