MySQL 8.0

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

create table mytable (
  id int,
  name  varchar(20),  
  low int,
  high int,
  high_low_adjstmnt int,    
  volume int
);

insert into mytable values
(1,   'Apple',   5 ,  3,         -2,                   1000),
(2,   'Orange',  6 ,  9,          3,                   2000),
(3,   'Banana',  13,  17,         4,                   3000),
(4,   'Avocado', 11,  19,         8,                   4000),
(5,   'Berry',   21,  17,        -4,                   5000),
(6,   'Peach',   7,   9,          2,                   6000),
(7,   'Mango',  9,   14,         5 ,                  7000),
(8,   'Grape',   18,  11,         7,                   8000),
(9,   'Kiwi' ,   14,  13,        -1,                   9000);

Records: 9  Duplicates: 0  Warnings: 0


select t2.*
from mytable t
inner join mytable t2 on t.id = t2.id - 1 or t.id = t2.id or t.id = t2.id + 1
where t.high_low_adjstmnt < 0


id
name
low
high
high_low_adjstmnt
volume


1
Apple
5
3
-2
1000

2
Orange
6
9
3
2000

4
Avocado
11
19
8
4000

5
Berry
21
17
-4
5000

6
Peach
7
9
2
6000

8
Grape
18
11
7
8000

9
Kiwi
14
13
-1
9000


with cte as (
  select *, lag(id) over(partition by id order by id) as lag
  from mytable
)
select *
from cte;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lag
  from mytable
)
select *
from cte' at line 2

id	name	low	high	high_low_adjstmnt	volume
1	Apple	5	3	-2	1000
2	Orange	6	9	3	2000
4	Avocado	11	19	8	4000
5	Berry	21	17	-4	5000
6	Peach	7	9	2	6000
8	Grape	18	11	7	8000
9	Kiwi	14	13	-1	9000