获取第一条数据

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

 

posted @ 2018-03-27 12:05  lhm_java  阅读(356)  评论(0编辑  收藏  举报