I have the following sql statement in strsql
SELECT B.SPCODE,a.revyr,a.revmo,a.dispos
FROM GNLIB/SFED201 A join GNLIB/SFAM B on ULSAM=LSAMS#
ORDER BY b.spcode,a.revyr,a.revmo
which gives me this
com yer mo dis
3006 2002 11 1
3006 2002 11 5
3006 2002 11 3
3007 2002 5 1
3007 2002 5 2
3007 2002 6 1
i want to count the dis field by month
3006 2002 11 3
3007 2002 5 2
3007 2002 6 1
SELECT B.SPCODE,a.revyr,a.revmo,a.dispos
FROM GNLIB/SFED201 A join GNLIB/SFAM B on ULSAM=LSAMS#
ORDER BY b.spcode,a.revyr,a.revmo
which gives me this
com yer mo dis
3006 2002 11 1
3006 2002 11 5
3006 2002 11 3
3007 2002 5 1
3007 2002 5 2
3007 2002 6 1
i want to count the dis field by month
3006 2002 11 3
3007 2002 5 2
3007 2002 6 1
Comment