表字段不为空时显示原来的，为空时默认为1，SQL语句

最新推荐文章于 2022-07-01 11:44:31 发布

Diamond79

最新推荐文章于 2022-07-01 11:44:31 发布

阅读量1.3k

点赞数

文章标签： sql join sql server null

本文链接：https://blog.csdn.net/Diamond79/article/details/1886554

版权

SQL SERVER

select   pd_sys_accounts.account,pd_sys_accounts.name,
ISNULL(OB_ACCOUNT_ADDTIONAL.SKILLLEVEL,1)
from   pd_sys_accounts
left   join   OB_ACCOUNT_ADDTIONAL
on   pd_sys_accounts.account=OB_ACCOUNT_ADDTIONAL.ACCOUNT

Acess

select   pd_sys_accounts.account,pd_sys_accounts.name,
IIF(OB_ACCOUNT_ADDTIONAL.SKILLLEVEL IS NULL,1,OB_ACCOUNT_ADDTIONAL.SKILLLEVEL)
from   pd_sys_accounts
left   join   OB_ACCOUNT_ADDTIONAL
on   pd_sys_accounts.account=OB_ACCOUNT_ADDTIONAL.ACCOUNT

其他方法：

SELECT pd_sys_accounts.account, pd_sys_accounts.name,
(CASE OB_ACCOUNT_ADDTIONAL.SKILLLEVEL WHEN NULL
THEN '1 ' ELSE SKILLLEVEL END) AS SKILLLEVEL
FROM pd_sys_accounts LEFT JOIN
OB_ACCOUNT_ADDTIONAL ON
pd_sys_accounts.account = OB_ACCOUNT_ADDTIONAL.ACCOUNT

select pd_sys_accounts.account,pd_sys_accounts.name,max(case OB_ACCOUNT_ADDTIONAL.SKILLLEVEL is null then 1)
from pd_sys_accounts
left join OB_ACCOUNT_ADDTIONAL
on pd_sys_accounts.account=OB_ACCOUNT_ADDTIONAL.ACCOUNT