ChinaUnix.net
相关文章推荐:

informix when case

informix7.3.1for UnixWare怎么还不支持case when用法。 请问UnixWare上哪个版本开始支持?

by lish_bin - Informix - 2006-01-09 23:40:39 阅读(1499) 回复(5)

相关讨论

现在有一个语句 select…… (case when co.status &128 = 128 then 'Act/Del' when co.status &64 = 64 then 'Pend/Act' when co.status &32 = 32 then 'active' end) from…… 想问一下如果不用case……when……,还有办法实现这个功能吗?

by gengpengfeiX - Oracle - 2008-03-04 09:00:24 阅读(1638) 回复(1)

这是我的sql 语句: SELECT job_addrc,date_format(job_time,'%Y-%m-%d') as regdate, sum(case job_status when 50 then 1 else 0 end) as us50, sum(case job_status when 60 then 1 else 0 end) as us60, sum(case job_status when 70 then 1 else 0 end) as us70, sum(case job_status when 80 then 1 else 0 end) as us80 FROM job_info where job_time between '2001-1-22' and '2009-2-25' group by regdate,job_addrc o...

by cxr1217 - MySQL - 2009-02-25 10:45:01 阅读(4535) 回复(5)

这样写是对的:case value when 5 then '高' else '中' end case 我现在想实现这样的逻辑:case value when >=5 then '高' else '中' end case 报语法错误。 如何解决? 谢谢

by admin159 - Informix - 2007-04-06 21:52:31 阅读(4232) 回复(2)

在odbc中是否不能使用case when? 原以为是ODBC版本问题,已升到3.82,也算是比较新的了,依然报错。 是否有些什么需要设置?

by euzen - Informix - 2009-04-02 08:57:56 阅读(1318) 回复(1)

sqlserver的case when 语句如何转 mysql 如以下sqlserver select ifnull(case when adid>1 then adid end),0) from advertisement 不知道是否mysql有对应sql

by liyihongcug - MySQL - 2006-12-15 10:45:23 阅读(1677) 回复(5)

如下面的sqlserver的语句中的case when 语句有对应的mysql语句没有 select ap.AdPlanId ,(case when (ap.PlanType=4) then '统分' else case when (api.CPID='|9|') then '网吧' else isnull(cp.CPChnName,'') end end ) as CPName,ap.TotalNum,ap.HaveShowTimes from adplan

by liyihongcug - MySQL - 2006-12-13 15:18:45 阅读(910) 回复(1)

我往远程库表里面插数据、如下 insert into table_x ( …… ) select ( …… ) 其中 select 后面的句子里面含有 case when 条件语句、这时候插入数据就失败、报错如下:ORA-22804: remote operations not permitted on object tables or user-defined type columns。 当 select 里面没有 case when 的时候、插入就能成功了。完整句子如下: INSERT INTO tab_cum_timegrade_user@report ( rec_date, rec_type, city_code, mark_ty...

by 反清復明 - Oracle - 2004-06-18 11:15:54 阅读(1179) 回复(2)

warning: aalib-1.4rc5-fr2.i386.rpm: V3 DSA signature: NOKEY, key ID e42d547b error: Failed dependencies: libmad.so.0 is needed by mplayer-1.0pre2-12.hamigua libpostproc.so.0 is needed by mplayer-1.0pre2-12.hamigua libmad = 0.15.0b-1.firefly is needed by (installed) libmad-devel-0.15.0b-1.firefly ------where I can find the files needed above?

by yshld - Linux论坛 - 2003-12-28 17:16:50 阅读(445) 回复(1)

select Day_Id ,Day_In_Season ,Fst_Agc_Offc_Cd ,Fst_Agc_IATA_Cd ,Fst_Agc_Prnt_Offc_Cd ,Fst_Agc_Cty_Cd ,Fst_Agc_Rgn_Cd ,Fst_Agc_Cntry_Cd ,Fst_Agc_Own_Sys ,Pnr_Orig_Gds_Cd ,Carr_Cd ,Carr_Df_Ind ,Flt_Nbr ,Flt_Nbr_Sfx ,Flt_Rte_Cd ,Flt_Typ...

by tedagov - Oracle - 2008-07-21 10:53:49 阅读(2025) 回复(2)

请帮忙!在db2中case when then(sqlserver的语法) 该怎么写呀?

by yulanhua - DB2 - 2004-01-09 22:34:14 阅读(4483) 回复(2)