Results 1 to 2 of 2

Thread: employee name and salary from employee and salary table

  1. 07-03-2007 #1
    Himu
    Himu is offline
    Junior Member
    Join Date
    Jun 2006
    Answers
    4

    employee name and salary from employee and salary table

    Display all employee name and salary from employee and salary table for last 3 months where salary is >75000

    Reply With Quote Reply With Quote
  2. 07-04-2007 #2
    jamesravid
    jamesravid is offline
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: employee name and salary from employee and salary table

    select e.ename,s.salary
    from employee e,salary s
    where e.emp_id = s.emp_id
    and s.salary > 75000
    and s.sal_date >= add_months(sysdate, -3);


    Note :

    Add_months is an Oracle function which adds no months to the first parameter(date)

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact