Question

(b)
Write the SQL commands to answer the quires based on the following table:
Employ no
Deptname
Name
City
101
Admin
Kishore Swain
Delhi
102
Hr
Pradeep Das
Pune
103
Sales
Smita Kar
Bangalore
Mumbai
104
purase
Rohan Mishra
a. Suggest a suitable data type for the Deptname field.
b. To get details about the employ whose employ no is 103
c. Add a new record with the following details:
(105, 'Sales', "Jitendra Mohanty", "Delhi").​

Answer 1

Answer:

See attached picture for the answer