SQL Server 2022

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

-- Create table
CREATE TABLE YourTable (
    ID INT,
    col1 VARCHAR(10),
    col2 VARCHAR(10)
);



-- Insert sample data
INSERT INTO YourTable (ID, col1, col2) VALUES
(1, 'A', 'Bsp'),
(2, 'B', 'Ees'),
(3, 'Ç', 'Eee'),
(4, 'D', 'Esp'),
(5, 'E', 'Apt'),
(6, 'F', 'Dpt');
6 rows affected

-- Retrieve records between 'Bsp' and 'Esp'
-- Identify IDs for 'Bsp' and 'Esp'
DECLARE @id_bsp INT;
DECLARE @id_esp INT;

SELECT @id_bsp = ID FROM YourTable WHERE col2 = 'Bsp';
SELECT @id_esp = ID FROM YourTable WHERE col2 = 'Esp';

-- Retrieve records between 'Bsp' and 'Esp'
SELECT ID, col1, col2
FROM YourTable
WHERE ID > @id_bsp AND ID <= @id_esp;


ID
col1
col2


2
B
Ees

3
Ç
Eee

4
D
Esp