Subject Re: group by ??
Author danyschaer

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).