Subject | Re: group by ?? |
---|---|
Author | danyschaer |
Post date | 2008-06-09T20:28:31Z |
Hi Sean;
What I have to do is so simple; just to read the last record added to
each group.
Field PROC represent the group ID.
Field MOVI represent a unique primary key for each record in MOVI.
Field FECH represent the date/time of the imput as a string litereal in
format YYYYMMDDHHMM (YEAR-MONTH-DAY-OUR-MINUTES).
I have to read the last full record of each group. The table is so big,
may be 50.000 or more groups and 30 or more records each group.
Dany
What I have to do is so simple; just to read the last record added to
each group.
Field PROC represent the group ID.
Field MOVI represent a unique primary key for each record in MOVI.
Field FECH represent the date/time of the imput as a string litereal in
format YYYYMMDDHHMM (YEAR-MONTH-DAY-OUR-MINUTES).
I have to read the last full record of each group. The table is so big,
may be 50.000 or more groups and 30 or more records each group.
Dany