例下语句:
CREATE VIEW dbo.ViewC
AS
select 班级编号,count(*) as 人数,case when count(*)>=30 then '大班' else '小班' END as 班级名称
from 学生基本信息表
group by 班级编号
提示不支持CASE语句,请问在视图中该怎么处理?
...全文
2276打赏收藏
视图中不能用CASE语句,该怎么处理?
例下语句: CREATE VIEW dbo.ViewC AS select 班级编号,count(*) as 人数,case when count(*)>=30 then '大班' else '小班' END as 班级名称 from 学生基本信息表 group by 班级编号 提示不支持CASE语句,请问在视图中该怎么处理?
CREATE VIEW dbo.ViewC
AS
select 班级编号 , case when 人数 >= 30 then '大班' else '小班' END as 班级名称
from
(
select 班级编号,count(*) as 人数
from 学生基本信息表
group by 班级编号
) t