39.
(a) Write a Query to create a Table with the following structure
(2+3)
Table Product
Field
PID
Pname
Description
Price
Datatype
Char(4)
Varchar(20)
| Varchar(40)
Decimal
(b) Consider the following Vendor table and write the queries
Table Vendor
| VendorID VName
V001 Mother Dairy
V002
Havmor
| V003 | Amul
V004 Kwality Walls
DateofRegistration
| 20-01-2009
01-04-2015
1 2-05-2012
15-10-2013
Location
Delhi
Gujrat
Kolkata
Mumbai
Write a Query to display all records
(ii) Write a Query to add a new row with the following details
('V005', 'Vadilal', '2010-03-20'. 'Pune')
(ii) Write a query to modify the location of V003 from Kolkata to Gujrat
Answers
Answered by
5
Answer:
Refer to attatchment
Explanation:
Attachments:
Similar questions