select CNAME=case when CNAME is null then '4' else '1' end from SMPTEL where SMPTEL.Newtel='1585'select CNAME=case when CNAME is null then '456' else '123' end from SMPTEL where SMPTEL.Newtel='158'Newtel 没有158 如何让其显示 456现在

select CNAME=case when CNAME is null then '4' else '1' end from SMPTEL where SMPTEL.Newtel='1585'select CNAME=case when CNAME is null then '456' else '123' end from SMPTEL where SMPTEL.Newtel='158'Newtel 没有158 如何让其显示 456现在 select case 语句里 可以再套select case vb select case 这个语句? select Student.Sno,Sname,Ssex,Cname,Grade from Student,SC,Course where Student.Sno=SC.Sno and SC.Cnoorder by Student.Sno 用sql server对上述结果做分页显示,我以前没学过对分页不了解, VBA Str$=“Upper Case”难不成是定义一个变量Str是字符串型的?Upper “把谁转换成大写?Select Case a$Case A To ZStr$=Upper CaseCase a To zStr$=Lower CaseCase 0 To 9Str$=NumberCase ,,,,.,;Str$=Punctuato Select Case语句到底是什么意思?Private Sub C1_Click(Index As Integer)Select Case IndexCase 1Timer1.Enabled = FalseCase 0Timer1.Enabled = TrueEnd SelectEnd Sub这段的index是神马?case1、0又是神马? delphi编程 报错 parameter 'wh' not found?还有这事.Delphi(Pascal) codesql1:='select * from Da_setcloum where WH=:wh and col=:col and row:=row';with qrysetcloum dobeginclose;sql.Clear;sql.Add(sql1);parameters.ParamByName('wh').Value:='DA';param select case 语句怎么判断在某两个值之间如题 我要把 if a> 3 and a =5 and a 16 and a = 85 Grade = 优秀 Case Is > = 75 Grade = 良好 Case Is > = 70 Grade = 中等 Case Is > = 60 Grade = 及格 end Select 有错误,在vb select case x结构中,描述判断条件3 sql case when请教请教sql中case when 判断语句select 姓名,工龄,(case when (工龄>= '35') then 90%when (工龄>='30' and 工龄='20' and 工龄='10' and 工龄 if (pastart = -1) sql.append(select * from(); sql.append(select nid,sname,sdescription,nprice,sif (pastart = -1)sql.append(select * from();sql.append(select nid,sname,sdescription,nprice,simg,(CASE smctag WHEN '0' THEN '有货'WHEN '1' THEN ' case when then else end 能用在条件判断上么比如select * from app a where --在这加case when 可以么?select * from app a where case when a.id = 1 then a.name = '22' else a.name = '33' 这段文字的意思update student　　set grade = (　　select grade from　　(　　select id,　　case when score> 90 then 'a'　　when score > 80 then 'b'　　when score > 70 then 'c'　　else 'd' end grade　　from student　　) a SELECT select count(distinct b) from X_info where c=1;能放到一个CASE内么 不用where group by 等等因为有多个这样的case 所以 where 和groupby 都不能考虑.b是另一张表的主键. vfp程序错误求指出X=THIS.VALUETHISFORM.GRDDMB.RECORDSOURCETYPE=4DO CASECASE X=1THISFORM.GRDDMB.RECORDSOURCE=SELECT * FROM DMB WHERE LX=政治面貌CASE X=2THISFORM.GRDDMB.RECORDSOURCE=SELECT * FROM DMB WHERE LX=文化程度CASE X=3THISF 这语句什么意思select * from [Feedbacks] where QId=3 order by case when QId=3 then 1 else 2 end,QId这个语句什么意思select * from [Feedbacks] where QId=3 order by case when QId=3 then 1 else 2 end,QId VB中,select case 超级难!一定要用select case做!现在有2个string.string1=textbox1是输入4位邮政编码的,string2是显示邮政编码所对应的地区的.依照表如下：地区缩写-邮编范围NSW 1000—1999 2000—2599 2619—28