T
ThRnk
Guest
I'm working with Progress, and I have the following table
col1 col2 col3
---------------------------------------------------------
002478 ABC 2019-08-23 *
002478 ABC 2019-05-14
002588 CVMG 2019-01-07 *
002588 IP 2019-01-31 *
002588 MMG 2019-09-04 *
002588 MMG 2019-08-28
002588 NUSA 2019-11-04 *
002588 NUSA 2019-04-24
002746 IE 2019-01-15 *
003467 IE 2020-01-10
003467 IE 2020-03-13 *
I want to be able to get the latest occurrence based on col1 and col2.
For example
On col2, we have 3 occurrences of IE
col1 col2 col3
---------------------------------------------------------
... ... ...
002746 IE 2019-01-15 *
003467 IE 2020-01-10
003467 IE 2020-03-13 *
And on col1, we have 2 different numbers for these 3 results.
I need to get the lastest results based on them together.
Continue reading...
col1 col2 col3
---------------------------------------------------------
002478 ABC 2019-08-23 *
002478 ABC 2019-05-14
002588 CVMG 2019-01-07 *
002588 IP 2019-01-31 *
002588 MMG 2019-09-04 *
002588 MMG 2019-08-28
002588 NUSA 2019-11-04 *
002588 NUSA 2019-04-24
002746 IE 2019-01-15 *
003467 IE 2020-01-10
003467 IE 2020-03-13 *
I want to be able to get the latest occurrence based on col1 and col2.
For example
On col2, we have 3 occurrences of IE
col1 col2 col3
---------------------------------------------------------
... ... ...
002746 IE 2019-01-15 *
003467 IE 2020-01-10
003467 IE 2020-03-13 *
And on col1, we have 2 different numbers for these 3 results.
I need to get the lastest results based on them together.
All results I need are marked with *
Continue reading...