select *
from tableA a
where a.ScanDatetime
in (select max(b.ScanDatetime)
from tableA b
where b.CtnNo=a.CtnNo
)
and a.PONo='**********'
select *
from tableA a
where a.ScanDatetime
in (select max(b.ScanDatetime)
from tableA b
where b.CtnNo=a.CtnNo
)
and a.PONo='**********'