Use MySQl t increase Salary by percentage

[lrcroft1]

I have a table of employees that I want to give pay raises to. Part of the staff gets a 10% raise 5 employees and 12 employees gets a 5% pay raise.
I need a single query that will work for either of the groups.

[Old Pedant]

Feels like homework.

No company I know would be giving exactly 5% and 10% (especially in these times) and in any case with only 17 employees I'm sure it would be faster and easier to just go in and edit the data. Oh, and a company wouldn't care if it was done with one query or two.

And for homework, see rule 1.5 here:
http://www.codingforums.com/rules.htm

So convince us it's not homework or show us that you have made an effort to solve this.

It's really not hard, honest. Here's a hint: Look at the IF( ) function.

Oh, and in any case it would help a lot to show us the fields in the table that you are using.

[Len Whistler]

Originally Posted by lrcroft1

I have a table of employees that I want to give pay raises to. Part of the staff gets a 10% raise 5 employees and 12 employees gets a 5% pay raise.
I need a single query that will work for either of the groups.

Definitely a homework assignment, and the solution is in your post.

last_name | first_name | group

Smith | Kevin | 1
Brown | Jack | 2
Jackson | Bill | 2
Thompson | Jack | 2


----------------