how to optimize this query?

Posted by jest on Stack Overflow See other posts from Stack Overflow or by jest
Published on 2010-03-21T10:59:38Z Indexed on 2010/03/21 11:01 UTC
Read the original article Hit count: 199

select employee_id, last_name, salary, round((salary+(salary*0.15)), 0) as
NewSalary, (round((salary+(salary*0.15)), 0) - salary) as “IncreaseAmount” 
from employees;

© Stack Overflow or respective owner