MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE product_exp_date (
idproduct  INT,
exp_date DATE,
selling_price INT);

INSERT INTO product_exp_date VALUES
(8, '2022-11-01', 300),
(5, '2022-06-08', 370),
(5, '2022-06-09', 350),
(7, '2022-07-01', 380),
(5, '2022-09-20', 450),
(6, '2022-10-08', 140),
(6, '2023-06-08', 150);
SELECT p1.idproduct,
       p1.exp_date,
       p1.selling_price
FROM product_exp_date p1 
JOIN (
   SELECT idproduct,
       MIN(exp_date) AS minexp
   FROM product_exp_date
   GROUP BY idproduct
  ) AS p2
 ON p1.idproduct=p2.idproduct 
 AND p1.exp_date=p2.minexp
ORDER BY p1.idproduct;


idproduct
exp_date
selling_price


5
2022-06-08
370

6
2022-10-08
140

7
2022-07-01
380

8
2022-11-01
300


SELECT idproduct,
       exp_date,
       selling_price
FROM (
   SELECT idproduct,
          exp_date,
          selling_price,
          ROW_NUMBER() OVER (PARTITION BY idproduct ORDER BY exp_date) rn
   FROM product_exp_date
  ) AS p1
WHERE rn=1;


idproduct
exp_date
selling_price


5
2022-06-08
370

6
2022-10-08
140

7
2022-07-01
380

8
2022-11-01
300