SELECT vtiger_crmentity.crmid, vtiger_crmentity.modifiedtime,vtiger_crmentity.smownerid,
case when (vtiger_users.user_name not like '')
then vtiger_users.user_name
else vtiger_groups.groupname
end as user_name,
vtiger_cares.* FROM vtiger_cares
INNER JOIN vtiger_crmentity
ON vtiger_crmentity.crmid = vtiger_cares.caresid
INNER JOIN vtiger_carescf
ON vtiger_cares.caresid = vtiger_carescf.caresid
LEFT JOIN vtiger_caresgrouprelation
ON vtiger_cares.caresid = vtiger_caresgrouprelation.caresid
LEFT JOIN vtiger_groups
ON vtiger_groups.groupname = vtiger_caresgrouprelation.groupname
LEFT JOIN vtiger_users
ON vtiger_users.id = vtiger_crmentity.smownerid
WHERE vtiger_crmentity.deleted = 0
分享到:
相关推荐
sql数据库 转 Access SQL语句改写之 Case When Then When Then Else End!值得下载看看!资源免费,大家分享!! 更多免费资源 http://ynsky.download.csdn.net/
1 case when 写法 2 sum case when 用法 3 select 拼接字段 示例如下: when 2 then 'C' else 'D' end ) as '类型',count(*) as '数量' from table group by orderType
主要介绍了sql学习之CASE WHEN THEN ELSE END的用法,需要的朋友可以参考下
1. CASE WHEN 表达式有两种形式 代码如下:–简单Case函数 CASE sex WHEN ‘1’ THEN ‘男’ WHEN ‘2’ THEN ‘女’ ELSE ‘其他’ END –Case搜索函数 CASEWHEN sex = ‘1’ THEN ‘男’ WHEN sex = ‘2’ ...
我们都知道SQL中适用case when then来转化数据库中的信息 比如 select (case sex when 0 then '男' else '女' end) AS sex from studentInfo
,100 * SUM(CASE WHEN C# = '001' AND score >= 60 THEN 1 ELSE 0 END)/SUM(CASE WHEN C# = '001' THEN 1 ELSE 0 END) AS 企业管理及格百分数 ,SUM(CASE WHEN C# = '002' THEN score ELSE 0 END)/SUM(CASE C# ...
CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS 字段序号, a.name AS 字段名, CASE WHEN COLUMNPROPERTY...
mysql数据库中CASE WHEN语句。 case when语句,用于计算条件...语法简单 CASE 函数: 代码如下:CASE input_expression WHEN when_expression THEN result_expression [ …n ] [ ELSE else_result_expression END
when 条件1 then 值1 when 条件2 then 值2 else 其他值 END 别名 from 表名; 下面是一个分组求和示例: select sum(redpackmoney) as stota,ischeck from t_redpack group by isCheck 使用case ...
代码如下: –简单Case函数 CASE sex WHEN ‘1’ THEN ‘男’ WHEN ‘2’ THEN ‘女’ ELSE ‘其他’ END –Case搜索函数 CASE WHEN sex = ‘1’ THEN ‘男’ WHEN sex = ‘2’ THEN ‘女’ ELSE ‘其他’ END 这两种...
SELECT name AS Name, CASE category WHEN “Holiday” THEN “Seasonal” WHEN “Profession” THEN “Bi_annual” WHEN “Literary” THEN “Random” END AS “Pattern”FROM sales; 9 rows in set (0.00 ...
例如,下面的语句显示中文年月 代码如下: select getdate() as 日期,case month(getdate()) when 11 then ‘十一’ when 12 then ‘十二’ else substring(‘一二三四五六七八九十’, month(getdate()),1) end+’月...
判断类似一个班级的男生和女生的人数,用sum (cese when then ) 代码如下: select count(er.execute_result), sum(case er.execute_result when 1 then 1 else 0 end) completed, sum(case er.execute_result when 0...
case_value是要被判断的值或表达式,接下来是一系列的WHEN-THEN块,每一块的when_value参数指定要与case_value比较的值,如果为真,就执行statement_list中的SQL语句。如果前面的每一个块都不匹配就会执行ELSE块指定...
其中代码:SELECT CONVERT(nvarchar, e.bmdwdm) AS '报名单位代码', a.bmdwmc AS '报名单位', SUM(CASE e.khmkdm WHEN '01' THEN e.kkk ELSE 0 END) AS '汉字录入', SUM(CASE e.khmkdm WHEN '02' THEN e.kkk ELSE '' ...
本文实例讲述了mysql存储过程之case语句用法。分享给大家供大家参考,具体如下: 除了if语句,mysql提供了一个替代的...END CASE; 我们可以使用简单CASE语句来检查表达式的值与一组唯一值的匹配,上述sql中,case_e
然后有一种语法让我眼前一亮,case when then else end 当满足CASE设定的条件时,就可以执行then语句。由于我要做的分组查询统计,是要罗列每一种情况,而且根据输入的“管理员编号”不同返回不同结果,结果记录的...
在动态拼接字符串时,我们常会用到字符拼接,我对拼接的引号不理解,如: ...SUM(CASE Leave WHEN ’01’ THEN DaysNo END) AS [事假], SUM(CASE Leave WHEN ’02’ THEN DaysNo END) AS [病假] 简答: 简单的来说一般
(case course when ‘语文’ then score else 0 end) —判断 as 语文—别名作为列名 SELECT `name`, MAX( CASE WHEN course='\u8bed\u6587' THEN score END ) AS 语文, MAX( CASE WHEN course='\u6570\...