0

deptno = 20 where emp_id is divisible by 2

Set the value of deptno in the following order deptno = 20 where emp_id is divisible by 2 deptno = 30 where emp_id is divisible by 3 deptno = 40 where emp_id is divisible by 4 deptno = 50 where emp_id is divisible by 5 deptno = 10 for the remaining records.

22nd Aug 2022, 3:59 PM
Roshan Dsouza
1 Answer