InterviewSolution
Saved Bookmarks
| 1. |
Please help its urgent pls Write the answers based on the following table: Table: Manger Deptno -Deptname-Name- city S101- Sales- Pranjal Sharma- Delhi HR404- HR- Preeti Arora- Chennai P204- Purchase- Sukhmeen Singh- Bangalore AD990- Admin- Sukanya Kumar- Mumbai (i) Write a SQL query to change city of AD990 to Pune (ii) Write a query to display all the records of the table in ascending order of Deptname. (iii)Add a new record with the following details: (‘S106’, ‘Sales’, “Kritika Tuteja”, “Delhi”). |
| Answer» TE QUESTION PROPERLY | |