1️) Scalar Subquery in SELECT: SELECT e.emp_id, e.emp_name, e.salary, (SELECT ROUND(AVG(salary), 2) FROM employees WHERE dept_id = e.dept_id) AS dept_avg_salary FROM employees e; 2️) Correlated ...
There was an error while loading. Please reload this page. INSERT INTO departments (department_id, department_name) VALUES (101, 'HR'), (102, 'IT'), (103, 'Sales ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback