Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I increase percentage in SQL query / stored procedure?

How do I increase percentage in SQL query / stored procedure?[closed] been answered!

like image 542
stoopid Avatar asked Sep 01 '25 16:09

stoopid


1 Answers

Try this:

If you just want to select:

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

If you want to update

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'
like image 132
Chandu Avatar answered Sep 04 '25 12:09

Chandu