1、查询最大begindate的记录(一个clerkcode有多个begindate值的记录) ,相关子查询?in?:
select * from hi_psnjob a where a.begindate in ( select max(b.begindate) from hi_psnjob b where b.clerkcode = a.clerkcode)
1、查询最大begindate的记录(一个clerkcode有多个begindate值的记录) ,相关子查询?in?:
select * from hi_psnjob a where a.begindate in ( select max(b.begindate) from hi_psnjob b where b.clerkcode = a.clerkcode)