Write the answers based on the following table Name Manager:
Table: Manger
Deptno
S101
HR404
P204
City
Delhi
Chennai
Sukhmeen Singh Bangalore
Sukanya Kumar Mumbai
a. Suggest a suitable data type for the Deptname field.
b. Write a query to display all the records of the table.
Deptname
Sales
HR
Purchase
Admin
Name
Pranjal Sharma
Preeti Arora
AD990
C.Add a new record with the following details:
('s106, 'Sales, "Kritika Tuteja", "Delhi").
d) Display department name where city is Chennai
e) Display different cities in the manager table
f)Arrange all the recordsin ascending order department wise.
8) Change the Deptname HR to Admin HR.
Answers
Answered by
0
Answer:
Chennai,new Delhi NCR in
Similar questions