[SQL] Find out what data has changed in a table

I have a table inv, first time value inserted in inv table like below

Date Batch Item Quantity
30-09-2024 1 Apple 200
1-10-2024 2 Apple 40

After the table has update like below in same table

Date Batch Item Quantity
25-09-2024 1 Apple 100
30-10-2024 2 Apple 60

How can I get report like below?

Field New Value Old Value
Date 25-09-2024 30-09-2024
Quantity 60 40

Continue reading...