[Stackoverflow] [Progress OpenEdge ABL] How can I search the latests occurrences based on 2 columns?

Status
Not open for further replies.
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.

All results I need are marked with *

Continue reading...
 
Status
Not open for further replies.
Top