📋 SQL FETCH FIRST and OFFSET Tutorial

📄 SQL: FETCH FIRST & OFFSET

Use FETCH FIRST and OFFSET to limit rows — perfect for pagination, previews, and top-N queries.

📋 Sample employees Table

employee_id	name	salary
1	Arif	50000
2	Nasrin	55000
3	Rafi	52000
4	Ritu	61000
5	Faruk	58000

1️⃣ FETCH FIRST N ROWS ONLY

Goal: Get top 3 highest salaries.

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

✅ Output:

name	salary
Ritu	61000
Faruk	58000
Nasrin	55000

2️⃣ OFFSET N ROWS

Goal: Skip first 2 rows, show next 2 highest salaries.

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

✅ Output:

name	salary
Nasrin	55000
Rafi	52000

📌 Notes:

• FETCH FIRST N ROWS ONLY is supported in Oracle 12c+, PostgreSQL, and DB2.
• For MySQL use: LIMIT N OFFSET M

Equivalent in MySQL:

SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 2 OFFSET 2;

📌 Summary:
FETCH FIRST and OFFSET help paginate or limit results. Great for top salaries, previews, or skipping rows.

sql fetch first offset example, sql pagination query, oracle fetch rows, mysql limit offset, bangladeshi employee salary query, top 3 salaries sql, skip rows in sql query