Subject | Re: group by ?? |
---|---|
Author | danyschaer |
Post date | 2008-06-09T18:29:43Z |
Fabian,
Maybe I do not explain myself very well. The records that I must fetch,
are those that I get by running the select clause that I post in first
message, that is:
select "PROC", max("FECH") from "MOVI" group by "PROC"
... but I have to get all the columns for those records.
One way is to concatenate all the columns into the max(), but in that
case the server must do a big effort (MOVI is a big table).
Dany
Maybe I do not explain myself very well. The records that I must fetch,
are those that I get by running the select clause that I post in first
message, that is:
select "PROC", max("FECH") from "MOVI" group by "PROC"
... but I have to get all the columns for those records.
One way is to concatenate all the columns into the max(), but in that
case the server must do a big effort (MOVI is a big table).
Dany