Supposed
we have a table Employee that contains the id (emp_id), name (emp_name) and
working experience (experience) of each employee in a company. Write a query to
find the second employee in terms of experience in increasing order? (first being
the one with max experience)

Question

Answer

a.  SELECT emp_id, experience AS
second_max_exp FROM Employee WHERE experience < (SELECT MAX(experience) FROM
Employee);

Answer

b.  All are correct

Answer

c.  SELECT emp_id,
MAX(experience) AS second_max_exp FROM Employee WHERE experience < (SELECT
MAX(experience) FROM Employee);

Answer

d.  SELECT emp_id, experience AS
second_max_exp FROM Employee WHERE experience > (SELECT MAX(experience) FROM
Employee);

Crowdly

Supposed we have a table Employee that contains the id (emp_id), name (emp_name)...

Want instant access to all verified answers on moodle.usth.edu.vn?