3,491
社区成员
发帖
与我相关
我的任务
分享
select *
from table1
where (to_char(tranDate,'dd-mm-yyy')||(trim(tranId))||(trim(tranSrlNum)) = (
select max((to_char(tranDate,'dd-mm-yyy')||(trim(tranId))||(trim(tranSrlNum)) )
from table1
where pID = '1234567'
)
select *
from( select row_number()over(partition by pID order by tranDate desc) row_,
t.*
from table1)
where row_ = 1
and pid='' --加条件
select *
from( select row_number()over(partition by pID order by tranDate desc) row_,
t.*
from table1
)
where row_ = 1 and pID = '1234567'
select *
from( select row_number()over(partition by pID order by tranDate desc) row_,
t.*
from table1)
where row_ = 1;