>Thanks for reply. but your trick won't work.
>
>When you issue
>
>select cparentid,max(ddate) from table1 group by cparentid
>
>This will not give me the details of the record which has highest date.
>This will give group's last records information .
>
>Mark
Use 2 selects
select cparentid,max(ddate) from table1 group by cparentid into cursor max1
select t.* from table1 t, max1 x ;
where t.cparentid = x.cparentid
and t.ddate = x.ddate
-TomC