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"?

image.pngimage.png
  1. A.

    select avg(salary) from EMP whose grade = "E4";

  2. B.

    select avg(salary) from EMP having grade = "E4";

  3. C.

    select avg(salary) from EMP group by grade where grade = "E4";

  4. 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 free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…