Select CHEXIAO_DATE,CHEXIAO_TYPE,GRANT_UNIT,LICENSE_NUM from W_CHEXIAO a where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310' and CHEXIAO_DATE = (select max(CHEXIAO_DATE) from W_CHEXIAO b where a.GRANT_UNIT =b.GRANT_UNIT and a.CHEXIAO_TYPE = b.CHEXIAO_TYPE and a.LICENSE_NUM = b.LICENSE_NUM and license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310') ;
Select CHEXIAO_DATE,CHEXIAO_TYPE,GRANT_UNIT,LICENSE_NUM from W_CHEXIAO a where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310' and CHEXIAO_DATE = (select max(CHEXIAO_DATE) from W_CHEXIAO b where a.LICENSE_NUM = b.LICENSE_NUM ) ;
from W_CHEXIAO a
where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310'
and CHEXIAO_DATE =
(select max(CHEXIAO_DATE)
from W_CHEXIAO b
where a.GRANT_UNIT =b.GRANT_UNIT
and a.CHEXIAO_TYPE = b.CHEXIAO_TYPE
and a.LICENSE_NUM = b.LICENSE_NUM
and license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310')
;
from W_CHEXIAO a
where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310'
and CHEXIAO_DATE =
(select max(CHEXIAO_DATE)
from W_CHEXIAO b
where a.LICENSE_NUM = b.LICENSE_NUM
)
;