>SET ENGINEBEHAVIOR 70 >SELECT ; > pi_id,; > pitype_id,; > MAX(expdate); > FROM PI ; > WHERE eqtype_id=2 AND equip_id=2246 ; > GROUP BY 2; > INTO CURSOR cc1 >>
>SET ENGINEBEHAVIOR 80 >SELECT ; > pi_id,; > pitype_id,; > MAX(expdate); > FROM PI ; > WHERE eqtype_id=2 AND equip_id=2246 ; > GROUP BY 1,2; > INTO CURSOR cc1 >>
SELECT ; pi_id,; pitype_id,; expdate ; FROM PI t1 ; WHERE eqtype_id=2 AND equip_id=2246 ; and expdate = ; (select max(expdate) from pi t2 where t1.pitype_id = t2.pitype_id) ; INTO CURSOR cc1Cetin