Question

answer question (v)​

Answer 1

ANSWER :-

(i) Select Name, Salary from COMPANY;

(ii) Select * from COMPANY where Dept = 'Accountant' ;

(iii) Update COMPANY set Salary = 'Salary +2000' where Dept = 'Supervisor' ;

(iv) Insert into COMPANY('Emp_Code' ,'Name', 'Salary', 'Dept', 'Joining_Date') values (106, 'Avinash', 28000, 'Clerk', 2012-07-05);

(v) Select * from COMPANY order by 'Salary' dsc;

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

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