Advertisement
DimitarVasilev

Untitled

May 23rd, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.43 KB | None | 0 0
  1. SELECT first_name||' '||last_name, hire_date, trunc((sysdate-hire_date)/365,2) STAJ, MIN(salary) FROM(
  2. 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
  3. WHERE trunc((sysdate-hire_date)/365,2)>=10
  4. AND e.employee_id=jh.employee_id
  5. AND UPPER(jh.job_id) = UPPER('it_prog')
  6. ORDER BY e.SALARY DESC)
  7. WHERE rownum <= 3
  8. GROUP BY first_name, last_name, hire_date;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement