本文共 456 字,大约阅读时间需要 1 分钟。
数据表内容:
SELECT * FROM runoob.runoob_tbl;统计runoob_title重复次数大于1的个数(HAVING子句设置重复数大于1。):
select count(runoob_title) as repetitions, runoob_title,runoob_author from runoob_tbl group by runoob_title having repetitions>1;过滤重复runoob_title重复的列:
select runoob_title,runoob_author submisson_data from runoob_tbl group by runoob_title;删除重复数据:
create table tmp select * from runoob_tbl group by runoob_title;drop table runoob_tbl;alter table tmp rename to runoob_tbl;
转载地址:http://oqben.baihongyu.com/