Guys plz answer this question
Attachments:
Answers
Answered by
0
b) SELECT* FROM SQL COMMAND where Deptt=Testing;
c) SELECT* FROM SQL COMMAND where staffname like 'A'
d) UPDATE SQL COMMAND Set Allowance='2000' where Allowance='3000'
Same continues for all other four names
a) SELECT* FROM SQL COMMAND where allowance>1400<2000
Hope it helps u for tomorrow's exam
All the best
c) SELECT* FROM SQL COMMAND where staffname like 'A'
d) UPDATE SQL COMMAND Set Allowance='2000' where Allowance='3000'
Same continues for all other four names
a) SELECT* FROM SQL COMMAND where allowance>1400<2000
Hope it helps u for tomorrow's exam
All the best
Anonymous:
Thnq
Similar questions
Social Sciences,
6 months ago
Science,
6 months ago
Science,
6 months ago
Math,
1 year ago
Math,
1 year ago