Question

Q-2 Write the SqlCommands To answer the queries based on Employee table
06
EID
E Name
E Address
Designation Salary
1001
Rishabh Kumar New Delhi
TGT
15500
1002
Preet Singh
Faridabad
PGT
16000
1003
Nishi Kuman Sahibabad
TGT
14000
1004
Sanskriti ha Ghaziabad
TGT
16000
1005
Pankaj Kumar Old Delhi
PGT
18000
a) To Insert the following record - (1006 Sanjeev". "Shalimar garden". TGT 21000)
b) To display those employees whose salary is less than 15000
c) to modify the Designation TGT of employee whose name is "Preet Singh
d) To delete the record whose ID is 1003
e) Change the column name E_name to Employee with varchar(40).
1) Add a new column/field with the name join date date​

Answer 1

Answer:

skip this question best way don't take tention be relaxed