hi all
is there anyway to find the highest and the lowest price related to date ??
The result i am looking for :
Item 01
Lowest > 170.000 > 22 May 22
Highest > 189.000 > 04 Aug 22
Item 02
Lowest > 171.000 > 27 Jan 22
Highest > 192.500 > 04 Aug 22
for the price i can get from query using max and min
for the date , still clue how to find it
tq all