我正在尝试获取null值,但联合((和Nz((不起作用。
select Nz(delay_head,0) from sumb where dep_reg = 'er'
尝试
SELECT IIf(IsNull(delay_head),0,delay_head) AS [delay_head_result]
FROM sumb
WHERE dep_reg='er';