MySQL 8.0

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

create table horror (id int, groupId int, data varchar(20)) ;
insert into horror values
(1, 2, 'apple'), 
(2, 5, 'cinnemon'), 
(3, 5, 'bacon'), 
(4, 5, 'pickles'), 
(5, 5, 'wonka'), 
(6, 42, 'bar'), 
(7, 42, 'linux'), 
(8, 69, 'rocks'), 
(9, 69, 'joe'), 
(10, 69, 'bob'), 
(11, 101, 'briggs'), 
(12, 101, 'kinky_horror');

Records: 12  Duplicates: 0  Warnings: 0


select id, groupId, data
from (
  select id, groupId, data, row_number() over (partition by groupId order by id) rn
  from horror) t
where rn = 1


id
groupId
data


1
2
apple

2
5
cinnemon

6
42
bar

8
69
rocks

11
101
briggs


select id, groupId, data
from (
  select id, groupId, data, row_number() over (partition by groupId order by id desc) rn
  from horror) t
where rn = 1


id
groupId
data


1
2
apple

5
5
wonka

7
42
linux

10
69
bob

12
101
kinky_horror