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

[steve pittman]

OK - looked more closely at your example: Select cust_nbr, category, min(timestamp) From my_table Group by cust_nbr, name That should give, I believe, your preferred result in your example. This assumes that each cust# has exactly one name value. Their are not multiple names for a given cust#. note - select distinct and grouping are logically equivalent if grouping by all the output columns with no aggregation. ....steve pittman

Continue reading...