Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3.
- SELECT e.first_name AS "numele", j.job_id || ' ' AS "identificatorul jobului", e.hire_date AS "data angajari", e.employee_id AS "identificatorul angajatului" FROM jobs j, employees e WHERE j.job_id = e.job_id;
- 4.
- SELECT e.first_name || ', ' || e.job_id AS "Angajat_functie" FROM employees e;
- 5.
- SELECT first_name, salary FROM employees WHERE salary > 5000;
- 6.
- SELECT first_name, last_name, job_id, hire_date FROM employees WHERE last_name IN('Matos', 'Taylor') ORDER BY hire_date ASC;
- 7.
- SELECT last_name, first_name FROM employees WHERE last_name LIKE '__a%';
- 8.
- SELECT CURRENT_DATE || ' ' AS "Data_curenta" FROM dual;
- 9.
- SELECT e.first_name, e.last_name, MONTHS_BETWEEN(jh.end_date, jh.start_date) AS "Luni_lucrate" FROM job_history jh, employees e WHERE e.employee_id = jh.employee_id;
- 10.
- SELECT e.first_name, e.last_name, NVL(TO_CHAR(e.commission_pct), 'fara_comision') FROM employees e;
- 11.
- SELECT COUNT(*), job_id FROM employees GROUP BY job_id;
- 12.
- SELECT COUNT(DISTINCT manager_id) FROM employees;
- 13.
- SELECT MAX(salary) - MIN(salary) Diferente_salariale FROM employees;
- 14.
- 15.
- SELECT m.first_name || ' ' || m.last_name Muncitor, m.hire_date, man.first_name || ' ' || man.last_name Manager, man.hire_date FROM employees m, employees man WHERE m.manager_id = man.employee_id AND m.hire_date < man.hire_date;
- 16.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement