var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to use floor to ....
I am in a SQL class and the teacher has asked us to update a value by 100 if the id number is even using the floor function.
I am not looking for someone to write the expresion, but someone to explain how the floor function could be used to do this.
Any help would be greatly appreciated.
your lecturere probably wants to to divide your number by 2, get the floor() value and multiply it by 2 again to see if it is the same value
7/2 = 3.5
floor(3.5) = 3
3 x 2 = 6
so we know 7 is not even
8/2 = 4
floor(4) = 4
4 x 2 = 8
so we know 8 is even
Thanks a ton.
That was just the info i need to build my query. My brain must have been mush to not figure out that simple math.
just for FYI here is the query i cam up with, nothing complicated but with your help on the math i was able to come through.
SET Salary = Salary + 100
WHERE floor(empid / 2) * 2 = empid
SET Salary = Salary + 200
WHERE floor(empid / 2) * 2 != empid
Thanks again Matt, your a lifesaver!!!!