`
shuaijie506
  • 浏览: 136228 次
  • 性别: Icon_minigender_1
  • 来自: 郑州
社区版块
存档分类
最新评论
收藏列表
标题 标签 来源
oracle 删除重复记录 oracle 
delete from h_mat_out_item_chai
 where vc_mid = 'b04c8989190c4e60b244281c90a2f0fa'
   and (vc_itemid, vc_pro) in
       (select vc_itemid, vc_pro
          from h_mat_out_item_chai t
         where vc_mid = 'b04c8989190c4e60b244281c90a2f0fa'
         group by vc_itemid, vc_pro
        having count(*) > 1)
   and rowid not in (select max(rowid)
                       from h_mat_out_item_chai
                      where vc_mid = 'b04c8989190c4e60b244281c90a2f0fa'
                      group by vc_itemid, vc_pro
                     having count(*) > 1)
正则表达式判断汉字 正则表达式 
[\u4e00-\u9fa5]+
Global site tag (gtag.js) - Google Analytics