SQL Server 2019 (Linux)

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

CREATE TABLE PRICE_DATA(
  PRODUCT_CODE VARCHAR(50),
  PRICING_DATE 	DATETIME,
  PRICE FLOAT
);


INSERT INTO PRICE_DATA VALUES ('1234','01-01-2022',	23.9);
INSERT INTO PRICE_DATA VALUES ('1234','02-01-2022',	23.9);
INSERT INTO PRICE_DATA VALUES ('1234','03-01-2022',	23.9);
INSERT INTO PRICE_DATA VALUES ('1234','04-01-2022',	22.9);
INSERT INTO PRICE_DATA VALUES ('1234','05-01-2022',	22.9);
INSERT INTO PRICE_DATA VALUES ('1234','06-01-2022',	24.9);
INSERT INTO PRICE_DATA VALUES ('1234','07-01-2022',	24.9);
INSERT INTO PRICE_DATA VALUES ('1234','08-01-2022',	23.9);
INSERT INTO PRICE_DATA VALUES ('1234','09-01-2022',	23.9);
9 rows affected

    SELECT *,
           ROW_NUMBER() OVER(ORDER BY PRICING_DATE) - ROW_NUMBER() OVER(PARTITION BY  PRODUCT_CODE,PRICE ORDER  BY PRICING_DATE) grp
    FROM PRICE_DATA 
    ORDER BY grp


PRODUCT_CODE
PRICING_DATE
PRICE
grp


1234
2022-01-01 00:00:00.000
23.9
0

1234
2022-02-01 00:00:00.000
23.9
0

1234
2022-03-01 00:00:00.000
23.9
0

1234
2022-04-01 00:00:00.000
22.9
3

1234
2022-05-01 00:00:00.000
22.9
3

1234
2022-08-01 00:00:00.000
23.9
4

1234
2022-09-01 00:00:00.000
23.9
4

1234
2022-06-01 00:00:00.000
24.9
5

1234
2022-07-01 00:00:00.000
24.9
5


SELECT  Product_Code,
        min(Pricing_Date) AS Min_Date ,
        max(Pricing_Date) AS Max_Date, 
        price
FROM (
    SELECT *,
           ROW_NUMBER() OVER(ORDER BY PRICING_DATE) - ROW_NUMBER() OVER(PARTITION BY  PRODUCT_CODE,PRICE ORDER  BY PRICING_DATE) grp
    FROM PRICE_DATA 
) t1
GROUP BY grp,Product_Code,price
ORDER BY  min(Pricing_Date)


Product_Code
Min_Date
Max_Date
price


1234
2022-01-01 00:00:00.000
2022-03-01 00:00:00.000
23.9

1234
2022-04-01 00:00:00.000
2022-05-01 00:00:00.000
22.9

1234
2022-06-01 00:00:00.000
2022-07-01 00:00:00.000
24.9

1234
2022-08-01 00:00:00.000
2022-09-01 00:00:00.000
23.9

PRODUCT_CODE	PRICING_DATE	PRICE	grp
1234	2022-01-01 00:00:00.000	23.9	0
1234	2022-02-01 00:00:00.000	23.9	0
1234	2022-03-01 00:00:00.000	23.9	0
1234	2022-04-01 00:00:00.000	22.9	3
1234	2022-05-01 00:00:00.000	22.9	3
1234	2022-08-01 00:00:00.000	23.9	4
1234	2022-09-01 00:00:00.000	23.9	4
1234	2022-06-01 00:00:00.000	24.9	5
1234	2022-07-01 00:00:00.000	24.9	5