1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need Help With Join's

Discussion in 'SQL PL/SQL' started by cfoucault1, Jul 14, 2010.

  1. cfoucault1

    cfoucault1 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello

    I'm new to sql and am taking a class, and am needing some help with joins and other sql statements.

    This is the question I'm trying to figure out right now, any help would be great.

    Your boss wants to know the employees who work in department 50 or 60.
    Display last_name, e.department_id, job_id, job_title, min_salary, max_salary. Sort by job_title, last_name (employees, jobs table) (Oraclejoin) (NOTE:This query doesn’t use aggregate functions)
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    You may want to try Analytical functions in case you dont want to use aggregate functions. (Partition by job Id)