Oracle — 12c Sql Hands-on Assignments Solutions

Write a query to page through employee data, showing rows 21 to 30 (Offset 20, Fetch 10).

SELECT employee_id, first_name, last_name, hire_date FROM employees ORDER BY hire_date OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY; Problem 7: Calculate the exact number of months and years each employee has worked as of today's date. Output format: "14 years, 3 months". oracle 12c sql hands-on assignments solutions

SELECT department_id, last_name, salary, RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank, DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS dense_rank, ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY salary DESC) AS row_num FROM employees WHERE department_id IS NOT NULL ORDER BY department_id, salary DESC; Find the salary difference between each employee and the next highest paid employee in the same department. Write a query to page through employee data,

Oracle 12c, SQL, Assignments, PL/SQL, Window Functions Fetch 10). SELECT employee_id