2020国产成人精品视频,性做久久久久久久久,亚洲国产成人久久综合一区,亚洲影院天堂中文av色

分享

sql 專題

 醉人說(shuō)夢(mèng) 2021-09-14

查詢重復(fù)記錄

select * from idc_aqzrr where dwmc in (select dwmc from idc_aqzrr group by dwmc having count(dwmc) > 1)

=========================================

刪除重復(fù)記錄

delete from idc_yhsbxx where id not in (

  select a2.min_id from  (

     select min(id) as min_id from idc_yhsbxx group by dwmc)  as a2 

)

    轉(zhuǎn)藏 分享 獻(xiàn)花(0

    0條評(píng)論

    發(fā)表

    請(qǐng)遵守用戶 評(píng)論公約

    類似文章 更多