Postgres 13

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

CREATE TABLE fruit_table
    ("Product Code" varchar(2), "Product" varchar(6), "Date" date)
;
    
INSERT INTO fruit_table
    ("Product Code", "Product", "Date")
VALUES
    ('MG', 'Mango', '2020-01-25'),
    ('MG', 'Mango', '2020-01-26'),
    ('MG', 'Mango', '2020-01-27'),
    ('MG', 'Mango', '2020-01-28'),
    ('BN', 'Banana', '2019-01-15'),
    ('BN', 'Banana', '2020-01-19'),
    ('BN', 'Banana', '2020-01-20'),
    ('BN', 'Banana', '2016-01-20'),
    ('AP', 'APPLE', '2021-03-02')
;

SELECT * FROM fruit_table
9 rows affected



Product Code
Product
Date


MG
Mango
2020-01-25

MG
Mango
2020-01-26

MG
Mango
2020-01-27

MG
Mango
2020-01-28

BN
Banana
2019-01-15

BN
Banana
2020-01-19

BN
Banana
2020-01-20

BN
Banana
2016-01-20

AP
APPLE
2021-03-02


SELECT
    *,
    row_number() OVER (PARTITION BY "Product Code" ORDER BY "Date" DESC)
FROM fruit_table


Product Code
Product
Date
row_number


AP
APPLE
2021-03-02
1

BN
Banana
2020-01-20
1

BN
Banana
2020-01-19
2

BN
Banana
2019-01-15
3

BN
Banana
2016-01-20
4

MG
Mango
2020-01-28
1

MG
Mango
2020-01-27
2

MG
Mango
2020-01-26
3

MG
Mango
2020-01-25
4


SELECT
    *
FROM (
    SELECT
        *,
        row_number() OVER (PARTITION BY "Product Code" ORDER BY "Date" DESC)
   FROM fruit_table
) s
WHERE row_number <= 2


Product Code
Product
Date
row_number


AP
APPLE
2021-03-02
1

BN
Banana
2020-01-20
1

BN
Banana
2020-01-19
2

MG
Mango
2020-01-28
1

MG
Mango
2020-01-27
2

Product Code	Product	Date
MG	Mango	2020-01-25
MG	Mango	2020-01-26
MG	Mango	2020-01-27
MG	Mango	2020-01-28
BN	Banana	2019-01-15
BN	Banana	2020-01-19
BN	Banana	2020-01-20
BN	Banana	2016-01-20
AP	APPLE	2021-03-02