>>SELECT MAX(fp_dlvdat), fp_prccorn, fp_prcsoy ; >> FROM feedpric ; >> GROUP BY fp_prccorn, fp_prcsoy ; >> INTO CURSOR result >>>
>select fp_dlvdat, fp_prccorn, fp_prcsoy ; > FROM feedpric t1 ; > where fp_dlvdat == ; > (SELECT MAX(fp_dlvdat); > FROM feedpric t2 ; > where t1.fp_prccorn == t2.fp_prccorn and t1.fp_prcsoy == t2.fp_prcsoy) ; > INTO CURSOR result >>