sql - 如何增加 SQL 查询/存储过程的百分比？

Question

如何增加 SQL 查询/存储过程的百分比？ 已回答!

Answer 1

尝试这个:

如果您只想选择:

SELECT ename, esalary * 1.1 
  INTO name, salary 
    FROM employee 
 WHERE eno='113'

如果你想更新

UPDATE employee
   SET salary =  salary * 1.1 
--If the base salary is store in esalary then use 
--SET salary = esalary * 1.1
 WHERE eno='113'