Question

* Weute the answers based on the following table
Name Manager
Table Manager
Deatho Deftname Name
Slol
L Sales Peranta lshauna Delhi
HRYOU
Rretti Aura
Pd 04 Purchase Sukhmeen ingh Banglore
AD990 Admin
Sukanaya Kumar rumbail
a Display Department name where city is Chermai.
Chennai
6 Display diff. cities in the manager table.
(c) Arrange all the records in ascending orden
deperrtment wise
d) Change all the Dept name HR to Admin HR,​

Answer 1

.........

..................

...................... .

Answer 2

Answer:

a) SELECT "Dept Name" FROM "Manager Table" WHERE "City" = 'Chennai' ;

b) SELECT * FROM  "Manager Table" ORDER BY "Dept Name" ASC ;

c) UPDATE  "Manager Table"  SET "Dept Name" = 'Admin HR' WHERE      "Dept Name" = 'HR' ;