sql 的case when 语句
Selectprevent_SeepfromTable_F301(2)Casewhenlength(prevent_Seep)=1then‘无’Whenlength(pr...
Select prevent_Seep from Table_F301(2)
Case when length(prevent_Seep)=1 then ‘无’
When length(prevent_seep)=2, then ‘有’
When length(prevent_seep)>2 then substring(prevent_seep,2,length(prevent_seep))
这句话哪搓了?他报错 展开
Case when length(prevent_Seep)=1 then ‘无’
When length(prevent_seep)=2, then ‘有’
When length(prevent_seep)>2 then substring(prevent_seep,2,length(prevent_seep))
这句话哪搓了?他报错 展开
6个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询