update T_TREATMENT
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT )
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
这个更好一点
set status = '1',
modify_time = sysdate
where end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
不知道这个怎么样?
应该符合你的意思吧!
update T_TREATMENT
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )
set status = '1',
modify_time = sysdate
where soci_id = '000001'
and end_date = (select max(end_date) from T_TREATMENT where soci_id = '000001' )