How do I increase percentage in SQL query / stored procedure?[closed] been answered!
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'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With