RE: Using MIN in embedded SQL

[jose luis Hernandez <mac1999@xxxxxxxxx>]

Perhaps you can use something like this:


SELECT ordyr,count(*) FROM macfile WHERE ordyr =
    (SELECT min(ordyr) FROM macfile )
group by moda


Regards



> -----Original Message-----
> message: 1
> date: Thu, 10 Apr 2014 15:18:45 +0000
> from: Michael Smith <msmith@xxxxxxxxxxxxxx>
> subject: Using MIN in embedded SQL
>
> Disclaimer: My knowledge of SQL, and embedded SQL is limited.
>
> The following interactive SQL statement yields the following:
> SELECT ordyr,count(*) FROM macfile WHERE ordyr between 2003 and
> 2013 GROUP BY ordyr
>
> ORDYR     COUNT ( * )
> 2,003             225
> 2,004             392
> 2,005             447
> 2,006             248
> 2,007             379
> 2,008             544
> 2,009             262
> 2,010             568
> 2,011             532
> 2,012             288
> 2,013             314
>
> I need to be able to set an RPG program variable with the year
> results(2003).  Is this possible, if so, please provide a coding example.
>
> TIA
>
> Michael Smith