SELECT YRMCS,YR,YRMXMD
FROM CSMYST
WHERE YRMCS = ( SELECT MAX(YRMCS)
FROM CSMYST
WHERE STCD in ( SELECT STCD
FROM STHD
WHERE STNM = ‘测站名称’)
)
FROM CSMYST
WHERE YRMCS = ( SELECT MAX(YRMCS)
FROM CSMYST
WHERE STCD in ( SELECT STCD
FROM STHD
WHERE STNM = ‘测站名称’)
)
from (SELECT STCD FROM STHD WHERE STNM = ‘测站名称’) a,(SELECT MAX(YRMCS) maxyrmcs FROM CSMYST WHERE STCD = ’站码’) b,(SELECT YRMCS,YR,YRMXMD FROM CSMYST WHERE YRMCS = 最大值 ) c