取elecagreemodel表中 agreement_version 值最大的的协议号对应的协议名称,以及协议路径不为空的数据
select * from elecagreemodel t2 , (select agreement_no ,max(agreement_version) max from elecagreemodel group by agreement_no) t1
where
t2.agreement_no=t1.agreement_no and
t2.agreement_version=t1.max and t2.agreement_content_path like '%.aip'
select * from elecagreemodel t2 , (select agreement_no ,max(agreement_version) max from elecagreemodel group by agreement_no) t1
where
t2.agreement_no=t1.agreement_no and
t2.agreement_version=t1.max and t2.agreement_content_path like '%.aip'