查找所有记录中发布时间最近的那条

select P_ID from DE_Payment B where
P_Time=(select max(A.P_Time) from DE_Payment A
where A.PA_ID=B.PA_ID)