查询到每个字符出现的次数：
select cust_part_number,count(*) as cishu from T1 group by cust_part_number
查询出现次数超过2次的记录：
select distinct a.cust_part_number from T1 a,
(select cust_part_number,count(*) as cishu from T1 group by cust_part_number) b
where a. cust_part_number=b. cust_part_number and b.cishu>=2
你可以用聚合函数count(*)
select cust_part_number
from table
group by cust_part_number having count(*) > 2
这个2就是次数
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024