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: 179
hi!
the query is:
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;
can i optimize this round((salary+(salary*0.15)), 0) part in anyway, so that it doesn't appear twice..i tried giving it an alias but didn't work :(
© Stack Overflow or respective owner
