Question

SQL 中怎么把字符串转换为数字

我想从表A的字段B中查找出出现次数大于6次的内容,如果它们出现的次数大于6,就在页面上显示出来,小于等于6次则不显示,应该怎样写,用哪个函数,希望回答得详细一些,只有三十分了,全给你了

Answer 1

select B,count(*) as counts from A group by B having count(*) > 6

Answer 2

SELECT *
FROM A
GROUP BY B HAVING COUNT(*)>6