Question

Q38) (a) Write a Query to create a Table with the following structure.




(b) Consider the following Vendor table and write the queries

a) Write a Query to display all the records
b) Write a Query to add a new row with the following details
('V005', 'Vadilal', '2010-03-20','Pune')
c) Write a Query to modify the location of V003 from Kolkata to Gujarat​

Answer 1

Explanation:

a) CREATE TABLE tablename

(

Emp_no char(4),

Name varchar(25),

Salary Float,

Department varchar(15),

);

a) SELECT * FROM TABLE VENDOR;

b) INSERT INTO TABLE VENDOR (VendorID,VName, DateofRegistration,Location)

VALUES ('V005','Vadilal','2010-03-20','Pune');

C) UPDATE TABLE VENDOR

SET Location = 'Gujarat'

WHERE VendorID = 'V003';

Answer 2

ANSWER :-

(a)

Create Table tablename ["Emp_no" char(4),"Name" Varchar(25),"Salary" Float,"Department" Varchar(15)];

(b) (a)

Select * from VENDOR;

(b)

Insert into VENDOR

('Emp_no','Name','Salary','Department') values ('V005','Vadilal','2020-03-20','Pune');

(c)

Update VENDOR set Location ='Gujarat' where VendorID = 'V003';

HOPE THIS HELPS YOU!!!!!!!!!!!!!

PLEASE MARK IT AS BRAINLIST!!!!!!!!!