MySQL 8.0

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

CREATE TABLE mytable (
  id int,
  price decimal(5,2),
  start_time date
);

insert into mytable values
(1,  0.1  , '2023-01-01'),
(2,  0.3  , '2023-03-01'),
(3,  0.2  , '2023-02-01');

Records: 3  Duplicates: 0  Warnings: 0


select *, lead(start_time) over (order by start_time) as end_time
from mytable


id
price
start_time
end_time


1
0.10
2023-01-01
2023-02-01

3
0.20
2023-02-01
2023-03-01

2
0.30
2023-03-01
null


select * from (
  select *, lead(start_time) over (order by start_time) as end_time
  from mytable
) as s
where price < 0.25


id
price
start_time
end_time


1
0.10
2023-01-01
2023-02-01

3
0.20
2023-02-01
2023-03-01

id	price	start_time	end_time
1	0.10	2023-01-01	2023-02-01
3	0.20	2023-02-01	2023-03-01
2	0.30	2023-03-01	null