场景:
取最大日期的最大时间
"先取最大日期的最大时间
SELECT SINGLE
MAX( zcjsj ) AS zcjsj,
zcjrq,
tcode,
ttext,
uname,
name_text,
zsejizh,
zuserid
FROM ztcode_log
INTO CORRESPONDING FIELDS OF @gs_alv
WHERE tcode = @ls_tcode-tcode
AND zcjrq = (
"先取最大日期
SELECT MAX( zcjrq )
AS zcjrq
FROM ztcode_log
WHERE tcode = @ls_tcode-tcode
)
GROUP BY
zcjsj,
zcjrq,
tcode,
ttext,
uname,
name_text,
zsejizh,
zuserid
.