Question

icture
39.
(a) Write a Query to create a Table with the following su
Table Employee
Field
Datatype
EID
Char(4)
Ename
Varchar(20)
Designation Varchar(40)
Salary
Decimal
(b) Consider the following Employee table and write the queries :
Table Employee
EID EName DateofJoining Location
E001 Mohan 20-01-2009 Delhi
E002 Harsh 01-04-2015 Gujrat
E003 Amrit 12-05-2012 Pune
E004 Kunal 15-10-2013 Mumbai
(i) Write a Query to display all records
(11) Write a Query to add a new row with the following details
('E005', 'Vineet', '2010-03-20', 'Kolkata')
(iii) Write a query to modify the location of E003 from Pune to
Ahemdabad
Information Technology/X/R-400
4(X)^]​

Answer 1

Answer:

Query to add a new row with the following details

EOO5, Vineet, 2010

Answer 2

Answer:

pls ask appropriate question...