Write the SQL query to create the table Manager with the given structure:
Deptno
Deptname
Name
City
S101
sales
pranjal
Delhi
HR404
HR
preeti
Chennai
P103
purchase
ravi
Bangalore
A115
admin
kavya
Mumbai
a. Suggest a suitable data type for the field Deptname.
b. Add a new record with the following data:
(‘F345’, ‘marketing’, ‘ geetha’, ‘Kolkata’)
c. Change the record of Preeti by updating her city to Pune.
d. Remove the record of pranjal.
e. Write a query to display all the records in the table.
Answers
Answered by
0
Explanation:
Got it!
This site uses cookies to deliver our services and to show you relevant ads. By using our site, you acknowledge that you have read and understood our Privacy Policy. Your use of w3resource Services, is subject
Answered by
0
Answer:
but eh shairi nhi hai Punjabi song hukam by karan aujla ki line hai
Attachments:
Similar questions