Question
How can I combine this to be a single statement in SQL? update employee set dno = 2 where ssn in (111111111, 333333333); update employee
How can I combine this to be a single statement in SQL?
update employee set dno = 2 where ssn in (111111111, 333333333); update employee set dno = 1 where ssn in (444444444, 888888888, 987654321); update employee set superssn = 888665555 where ssn in (333333333, 987654321);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Basics Computer EngineeringInformation Warehouse Basics From Science
Authors: Odiljon Jakbarov ,Anvarkhan Majidov
1st Edition
620675183X, 978-6206751830
