group by条件有关问题_Sql Server

group by条件问题
select count(materialprofile.F_SN) as qty,F_SN
from temp
where
F_closetime BETWEEN '2010-06-01' AND '2011-01-01'

想加个条件是qty > 2 的显示
这个条件怎么写呀

------解决方案--------------------

SQL code

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