Deptno
S101
HR404
P204
AD990
Deptname
Sales
HR
Purchase
Admin
Table: Manager
Name
Pranjal Sharma
Preeti Arora
Sukhmeen Singh
Sukanya Kumar
City
Delhi
Chennai
Bangalore
Mumbai
a) Suggest a suitable data type for the Deptname fie
b) Write a query to display all the records of the t
c) Add a new record with the following details:
('5106', 'Sales', 'Karitika Tuteja', 'Delhi').
d) Display department name where city is Chennai
e) Display different cities in the manager table
f) Arrange all the records in ascending order depa
wise.
g) Change the Deptname HR to Admin HR.
Answers
Answered by
0
Answer:
what is this ???? care to explain it
Explanation:
Similar questions