MySQL 5.7

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

CREATE TABLE tablename (
  `device_id` INTEGER,
  `section` VARCHAR(1)
);

INSERT INTO tablename
  (`device_id`, `section`)
VALUES
  ('100', 'A'),
  ('101', 'B'),
  ('102', 'B'),
  ('103', 'C'),
  ('104', 'D'),
  ('105', 'C'),
  ('106', 'A'),
  ('107', 'C');
select substring_index(group_concat(device_id order by rand()), ',', 1) device_id,
       section
from tablename
group by section


device_id
section


100
A

102
B

103
C

104
D


select substring_index(group_concat(device_id order by rand()), ',', 1) device_id,
       section
from tablename
group by section


device_id
section


106
A

101
B

103
C

104
D


select substring_index(group_concat(device_id order by rand()), ',', 1) device_id,
       section
from tablename
group by section


device_id
section


100
A

101
B

105
C

104
D