Merge Into For Update Example

weixin_30824277

于 2013-07-03 15:37:00 发布

阅读量91

点赞数

原文链接：http://www.cnblogs.com/krisy/p/3169613.html

版权

Merge Into article aa
  Using (
    SELECT md5_id, Min(article_id) as Min_Article_ID
    from article  
    WHERE created_time between (sysdate-10/(24*60)) and sysdate
    and Min_Article_ID is null    
    GROUP BY md5_id HAVING COUNT(*)>1
  ) sr
  ON (aa.md5_id=sr.md5_id)
  WHEN MATCHED THEN
  UPDATE 
  SET aa.Min_Article_ID=sr.Min_Article_ID,aa.samilar_record_count=1
  Where aa.created_time between (sysdate-10/(24*60)) and sysdate
  And aa.Min_Article_ID is null;