SELECT YLS.T_MFMINFO.G_BATCHYIELD FROM YLS.T_MFMINFO where YLS.T_MFMINFO.G_LFID = 'FZZB00002017121813213500000000' and YLS.T_MFMINFO.G_PDCFACID = 'JCT000320160324121800000170' Order By YLS.T_MFMINFO.G_UPDATETIME desc fetch first 1 row only
SELECT YLS.T_MFMINFO.G_BATCHYIELD FROM YLS.T_MFMINFO where YLS.T_MFMINFO.G_LFID = 'FZZB00002017121813213500000000' and YLS.T_MFMINFO.G_PDCFACID = 'JCT000320160324121800000170' Order By YLS.T_MFMINFO.G_UPDATETIME desc fetch first 1 row only
转载于:https://www.cnblogs.com/jlhm/p/8656751.html