Deptno-deptname-name-city
S101-sales-pranjal sharma-Delhi
HR404-HR-Preet arora- Chennai
P204-purchase-sukhmeen singh- Bangalore
Ad990-admin-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.
C. Add a new record with the following details:
('S106','sales',"kritika tuteja","delhi")
Answers
Answered by
17
A. Department name char(50)
B. SELECT "Table Name";
C. INSERT INTO "Table Name"
VALUES ( 'S106', 'Sales', 'Kritika Tuteja', 'Delhi');
NOTE: PLEASE INSERT THE NAME OF THE TABLE INSTEAD OF
"Table Name" WITHOUT QUOTES.
GAURAVg91
Answered by
8
Answer:
A. department name char(50)
B. select Table Manager
C. insert into manager(...)
Similar questions
Science,
7 months ago
English,
7 months ago
Math,
1 year ago
Computer Science,
1 year ago
Physics,
1 year ago