Question

www
6. Write SQL commands for the following questions on the basis of table MASTER (5)
To change the salary of the employee to 40000 whose S.No is 3.
ii) To display the age and department of those employees whose salary is greater than
12000.
iii) To display the name and department of those employees whose name starts with 'S'.
iv) To add a column Dol to the above table.
v) To display the department name in descending order.

Answer 1

Answer:

jdkdpsshfidosoajdfjdjospapa