MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Employees ( EmpID int NOT NULL PRIMARY KEY, Name varchar(255) NOT NULL,    Address  varchar(255),Phone varchar(255),  Salary varchar(255));
INSERT INTO Employees (EmpID, Name, Address, Phone, Salary)VALUES
('1', 'Nikhil', 'Delhi', '9878906543', '8000'),
('2', 'Divya', 'Ranchi', '8990076543', '5000'),
('3', 'Ravi', 'Bareilly', '7789945765', '7000'),
('4', 'Anna', 'Noida', '9789945760', '4000'),
('5', 'Surbhi', 'Jaipur', '7800541123', '5500');

Records: 5  Duplicates: 0  Warnings: 0


SELECT Name, Address FROM Employees ORDER BY Salary OFFSET 2 ROWS
FETCH NEXT 2 ROWS ONLY;


Name
Address


Surbhi
Jaipur

Ravi
Bareilly