🏆 Practice: Top Earners & Latest Hires

Use SQL ORDER BY, FETCH FIRST, and OFFSET to find high-salary employees and the most recent hires.

📋 Sample employees Table

id	name	salary	hire_date
1	Arif	50000	2020-06-01
2	Nasrin	58000	2021-03-12
3	Faruk	62000	2022-09-25
4	Ritu	54000	2023-01-15
5	Rafi	61000	2023-07-30

🧠 Task 1: Top 3 Highest Earners

SELECT name, salary
FROM employees
ORDER BY salary DESC
FETCH FIRST 3 ROWS ONLY;

✅ Output:

name	salary
Faruk	62000
Rafi	61000
Nasrin	58000

🧠 Task 2: Latest 2 Hires

SELECT name, hire_date
FROM employees
ORDER BY hire_date DESC
FETCH FIRST 2 ROWS ONLY;

✅ Output:

name	hire_date
Rafi	2023-07-30
Ritu	2023-01-15

🧠 Task 3: 2nd and 3rd Top Earners

SELECT name, salary
FROM employees
ORDER BY salary DESC
OFFSET 1 ROWS
FETCH FIRST 2 ROWS ONLY;

✅ Output:

name	salary
Rafi	61000
Nasrin	58000

📝 Summary

• FETCH FIRST N ROWS: returns the top N rows
• OFFSET N: skips the first N rows
• Use ORDER BY to control row ranking

sql fetch first offset practice, top 3 salaries query, latest hire date sql, sql pagination examples, bangladeshi employee salary practice, order by fetch offset query