Slip 2 - D) Consider the above tables and execute the following queries: 1. Delete sales order details of client whose name is “Patil” and order date is “09/08/2019”. 2. Change order date of client_No ‘CN001’ to ‘18/03/2019’. 3. Delete all sales_record having order date is before ‘10 /02/2018’. 4. Display date wise sales_order given by clients. 5. Update the address of client to “Pimpri” whose name is ‘Mr. Roy’.
0 Comments