Cognizant Handson - Hunger eats - update table

 

Hunger eats - update table


Refer to the given schema diagram and sample records inserted into the Customers table.

 


Update records based on the given requirement.

Requirement 1: update the phone no of the Customers whose id is 'CUST1004' to the new phone no  '9876543210'


NOTE: Maintain the same sequence of column order, as specified in the question description


SOLUTION:

update CUSTOMERS SET PHONE_NO=9876543210 WHERE CUSTOMER_ID='CUST1004';   

Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.