select testColume,count(*) as count
from testTable
group by testColume
having count >1
注:testColume即要筛选的重复字段。以该字段分组,再计算每组数目,找到数目大于一的,即重复的记录。
此处注意sql语句执行顺序:
1.from
2.where
3.group by
4.having
5.select
select testColume,count(*) as count
from testTable
group by testColume
having count >1
注:testColume即要筛选的重复字段。以该字段分组,再计算每组数目,找到数目大于一的,即重复的记录。
此处注意sql语句执行顺序:
1.from
2.where
3.group by
4.having
5.select