Computer Science
Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it.
DDL & DML
3 Likes
Answer
ALTER TABLE Empl
ADD (Grade VARCHAR(1)) ;
Answered By
2 Likes
Related Questions
Enlist the names of all tables created by you.
Write Query statements for following transaction : (Consider tables of question 12)
- Increase price of all products by 10%.
- List the details of all orders whose payment is pending as per increased price.
- Decrease prices by 10% for all those products for which orders were placed 10 months before.
In the added column Grade, assign grades as follows :
if sal is in range 700 — 1500, Grade is 1 ;
if sal is in range 1500 — 2200, Grade is 2 ;
if sal is in range 2200 — 3000, Grade is 3 ;
if sal is in range 3000 — Grade is 4 ;Add a constraint (NN-Grade) in table Empl that declares column Grade not null.