select count(materialprofile.F_SN) as qty,F_SN  
from temp
where  
F_closetime BETWEEN '2010-06-01' AND '2011-01-01'  
group by F_SN having count(materialprofile.F_SN)>2

------解决方案--------------------
SQL code
select count(materialprofile.F_SN) as qty,F_SN 
from temp
where 
F_closetime BETWEEN '2010-06-01' AND '2011-01-01'  
group by F_SN 
having count(materialprofile.F_SN)>2

------解决方案--------------------
SQL code
select count(*) as qty,F_SN  
from temp
where  
F_closetime BETWEEN '2010-06-01' AND '2011-01-01'
group by F_SN
having count(*)>2

------解决方案--------------------
SQL code
select
 count(materialprofile.F_SN) as qty,F_SN 
from
 temp
where 
 F_closetime BETWEEN '2010-06-01' AND '2011-01-01'  
group by
 F_SN 
having
 count(1)>2