2019年8月7日

SQL 删除重复记录,只保留一条记录

摘要: DELETE FROM py_bond_shenzhen_exchange_opinion_2_1 WHERE id NOT IN (SELECT id FROM (SELECT min(id) AS id FROM py_bond_shenzhen_exchange_opinion_2_1 GROUP BY notice_date, notice_title) temp) 阅读全文

posted @ 2019-08-07 10:36 swustqiu 阅读(384) 评论(0) 推荐(0) 编辑

导航