User Tools

Site Tools


kurs:update
update emp_copy set bonus = salary * 
   (case when salary < 5000 then 0.2
         when salary < 10000 then 0.1 
         else 0
    end)
kurs/update.txt · Last modified: 2014/09/10 21:22 (external edit)