找出最後一次AEJ為何
select cl63_trancode
from cl63_lab_medi
where cl63_trandate =
(select max(cl63_trandate)
from cl63_lab_medi
where cl63_empno='040010' and (cl63_trancode='A' or cl63_trancode='E' or cl63_trancode='J'))
from cl63_lab_medi
where cl63_trandate =
(select max(cl63_trandate)
from cl63_lab_medi
where cl63_empno='040010' and (cl63_trancode='A' or cl63_trancode='E' or cl63_trancode='J'))
0 Comments:
Post a Comment
<< Home