sql - Conditionally replacing values in SELECT -


I have a query that gives the amount of wages for a given member of the employee

 Select  Overall * Neutroprave staff staff = = staffref  

from the total cost as a staff bauerate however, if the value returned is> 105, then I would like to add an extra bit of math need to. To do so, if the value is & lt; 105 is returned as value, although if value is> 105 then I need to value * 1.128.

For example:

John Smith's cost is 90; Therefore, the cost of David Smith is 140 so the query is 157.92

should come back I'm sure there is some way to use it to use it, but I only want

Try to do something like that.

  Select TotalCost = Case (Totalhors * StaffbaseAet) & lt; 105 THEN (Total Staffestate) ELSE (Total House * StaffBoAreate) * 1.128 Android from Nutrotra, where stafff = @steff  

Comments