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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only