Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT first_name||' '||last_name, hire_date, trunc((sysdate-hire_date)/365,2) STAJ, MIN(salary) FROM(
- SELECT e.first_name, e.last_name, e.SALARY, e.hire_date, trunc((sysdate-e.hire_date)/365,2) STAJ FROM employees e, job_history jh
- WHERE trunc((sysdate-hire_date)/365,2)>=10
- AND e.employee_id=jh.employee_id
- AND UPPER(jh.job_id) = UPPER('it_prog')
- ORDER BY e.SALARY DESC)
- WHERE rownum <= 3
- GROUP BY first_name, last_name, hire_date;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement