[progress Communities] [progress Openedge Abl] Forum Post: Re: Select Distinct Over Jdbc...

[steve pittman]

Hi Jason, If I understand your example correctly, you want to use standard sql GROUP BY functionality to get what you want: Select cust_nbr, category, min(timestamp) From my_table Group by cust_nbr, category This will give you one cust with one category and use the smallest timestamp for the various records for the cust, category pair. Hope this helps, ….steve pittman

Continue reading...