Update with correlated subquery

SQL Medium 3 views
Back to Questions
Previous NOT IN pitfall with nulls (safe version) Medium P Next Find products priced above category average Hard N

Problem Description

Update Employees set salary to department average salary for employees who have salary NULL.

Input Format

SQL DML

Output Format

DML statement(s)

Sample Test Case

Input:
Employees
Output:
Rows updated

Constraints

Assume salary nullable
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next