大神帮解答一下吧
if pjob='PRESIDENT' then update emp set sal=sal+1000 where empno=pempno;
elsif pjob='MANAFER' then update emp set sal=sal+800 where empno=pempno;
else update emp set sal=sal+400 where empno=pempno;
为什么where后面跟着 empno=pempno;用职位限定不行么
else那个where后面可以用pjob<>'PRESIDENT' and pjob<>'MANAFER'
