急求SQL查询

[liqixing007]

select pd_sys_accounts.account,pd_sys_accounts.name,OB_ACCOUNT_ADDTIONAL.SKILLLEVEL
from pd_sys_accounts
left join OB_ACCOUNT_ADDTIONAL
on pd_sys_accounts.account=OB_ACCOUNT_ADDTIONAL.ACCOUNT
我要实现SKILLLEVEL不为空时显示原来的，为空时默认为1，怎么写SQL语句？在线等

[cylx00]

nvl(SKILLLEVEL,1)

[liqixing007]

结合1楼和6楼的SQL解决了，谢谢各位热心的高手！！！

[boblaw]

以下是ＳＱＬ 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 

[luoyinshuang]

做人事系统么？

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

[boblaw]

以下是Access

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 

[xuyang840117]

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

[liqixing007]

有没有在Oracle数据库中能用的呀，我们使的是Oracle8