Consider the following EMP table and answer the question below: Which of the…
PYQ KVS TGT/PGT 2013
Consider the following EMP table and answer the question below: Which of the following select statement should be executed if we need to display the average salary of employees who belong to grade "E4"?


- A.
select avg(salary) from EMP whose grade = "E4";
- B.
select avg(salary) from EMP having grade = "E4";
- C.
select avg(salary) from EMP group by grade where grade = "E4";
- D.
select avg(salary) from EMP group by grade having grade = "E4";
Attempted by 1683 students.
Sign up free to check your answer
Sign up freeLoading lesson…

