Subject group by ??
Author danyschaer
Hi All;

I have a table named MOVI with (as an example) this fields:

MOVI Char(10)
PROC Char(10)
DSCR Char(10)
FECH Char(8)
HORA Char(4)
DSCR Varchar(200)

I have to obtain all the fields for each record that is the MAX(FECH)
from groups of PROC:

select "PROC", max("FECH") from "MOVI" group by "PROC"

Like this, but I have to get all the fields. How can I do that?.

Thank you!