--为什么用别名不行
select FMRPName,
count(*) as ss FROM [PMSystem2].[dbo].[zt_plan_pro]
group by FMRPName having count(*)>3
--为什么用别名不行
select FMRPName,
count(*) as ss FROM [PMSystem2].[dbo].[zt_plan_pro]
group by FMRPName having ss>3
select FMRPName,
count(*) as ss FROM [PMSystem2].[dbo].[zt_plan_pro]
group by FMRPName having count(*)>3
--为什么用别名不行
select FMRPName,
count(*) as ss FROM [PMSystem2].[dbo].[zt_plan_pro]
group by FMRPName having ss>3