Hi All:
How do you retrieve the record that has the latest date from a table? I thought you use the MAX function but the following code gives me all the records from the table.
Thanks,
Yossi
SELECT MAX(fp_dlvdat), fp_prccorn, fp_prcsoy ;
FROM feedpric ;
GROUP BY fp_prccorn, fp_prcsoy ;
INTO CURSOR result