DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Help Query

  1. #1
    Join Date
    May 2008
    Posts
    2

    Help Query

    how can i



    increase the salary of each employee with the minimum salary paid in his department, except in the department requested by substitution variable and the department who paid the highest salary


    department anyone can help?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I would use a UPDATE statement according to the business specifications; what do you have so far?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    May 2008
    Posts
    2
    let me explain its just a query using Hr profile in oracle 10g express with the tipical tables employees, departments,country, etc...

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    You may want to ask your teacher for direction.
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135

    increase the salary of each employee with the minimum salary paid in his department, except in the department requested by substitution variable and the department who paid the highest salary
    Are you sure you want to increase the salary?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width