2 Replies - 743 Views - Last Post: 20 April 2012 - 05:41 AM

#1 luvzmychucks  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 16-April 12

SQL reports

Posted 16 April 2012 - 07:22 PM

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)


Is This A Good Question/Topic? 0
  • +

Replies To: SQL reports

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8963
  • View blog
  • Posts: 33,624
  • Joined: 12-June 08

Re: SQL reports

Posted 17 April 2012 - 09:47 AM

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?
Was This Post Helpful? 0
  • +
  • -

#3 rgfirefly24  Icon User is offline

  • D.I.C Lover
  • member icon


Reputation: 262
  • View blog
  • Posts: 1,461
  • Joined: 07-April 08

Re: SQL reports

Posted 20 April 2012 - 05:41 AM

View Postluvzmychucks, 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.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1