当前位置： 移动技术网 > IT编程>数据库>Oracle > Oracle数据库中分组取最小时间的那条记录的所有字段信息（方法）

Oracle数据库中分组取最小时间的那条记录的所有字段信息（方法）

2018年03月31日  | 移动技术网IT编程  | 我要评论

MERGE INTO user_member_info a

USING ( select min(UP.created) as cre,min(up.shop_no) as shop_no,up.memberid as memberid

from user_platform_relation up,

( select memberid as mid,min(created) as cre

from user_platform_relation

group by memberid) um

where up.created = um.cre and up.memberid = um.mid

group by up.memberid) b

ON (a.id = b.memberid

)

WHEN MATCHED THEN UPDATE SET a.created = b.cre,a.shop_no = b.shop_no,a.modified_time = sysdate

where a.shop_no is null;

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网