Re: SQL Question

[Steve Richter <stephenrichter@xxxxxxxxx>]

not with distinct. but you can group by and then order by min(TimeField)

Select  Company, Order from Myfile
Where userID=:value
group by company, order
Order by min(TimeField )

On Mon, Jan 13, 2020 at 12:15 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Using embedded SQL... I have a "Select Distinct" statement that is
> returning the result I need... However, I need the result set sorted by a
> field/row that is NOT in the distinct clause.  Is there a way to do this?
>
> Ex:
> Select distinct Company, Order from Myfile
> Where userID=:value
> Order by TimeField;
>
> This produces an SQL0214 error...
>
> Is there another way I'm not thinking about?
>
> Thx
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com