如何在SQL中取出出现在某一列中的的次数超过指定次数的清单？

2025-02-25 06:17:49

推荐回答（3个）

回答1：

查询到每个字符出现的次数：
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

回答2：

你可以用聚合函数count(*)

回答3：

select cust_part_number

from table

group by cust_part_number having count(*) > 2

这个2就是次数