You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum…

Question

Options

• ASELECT a.emp_name, a.sal, b.dept_id, MAX(sal) FROM employees a, departments b WHERE
• Bdept_id = b.dept_id AND a.sal < MAX(sal) GROUP BY b.dept_id;
• CSELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id,
• DSELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a WHERE a.sal < (SELECT
• ESELECT emp_name, sal, dept_id, maxsal FROM employees, (SELECT dept_id, MAX(sal) maxsal

• A
  15% (4)
• B
  73% (19)
• C
  8% (2)
• E
  4% (1)

Explanation

function MAX(column_name)

No community discussion yet for this question.