[luvzmychucks]

I am supposed to

Use the information from last week (attached)and execute commands that

permently increase salary to 10%

the output must contain:

Last_name
First_name
EEO_classification
salary

I have tried almost everything and I keep getting errors, Can someone provide an example of how this is
supposed to done?

Attached File(s)

•  Week 3 Data Changes and SQL statements with screen shots (2).doc (268K)
  Number of downloads: 19

[modi123_1]

Quote

I have tried almost everything and I keep getting errors, Can someone provide an example of how this is
supposed to done?

What errors? What are you doing? Where's your code you've been using?

[rgfirefly24]

luvzmychucks, on 16 April 2012 - 09:22 PM, said:

I am supposed to

Use the information from last week (attached)and execute commands that

permently increase salary to 10%

the output must contain:

Last_name
First_name
EEO_classification
salary

I have tried almost everything and I keep getting errors, Can someone provide an example of how this is
supposed to done?

Lets break this down

1. permently increase salary to 10%
So your going to take the Salary field add 10% to it and put it back into the Salary field.
This tells you you will need to use an update statement and set salary = salary * 1.10.

2. the output must contain....
Since UPDATE statements don't contain an "output", i'm going to assume you need to do another simple select statement to show the updated salaries. You've done this multiple times before so it shouldn't be an issue.


Now take the above and attempt to write your query. Come back if you still have trouble, but you need to supply the code you've written yourself, along with any error messages/expected output/funny behavior. With out that information there is not much more we can do to help unfortunately.