IBM DB2 11.5 clients and drivers

https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers?mhsrc=ibmsearch_a&mhq=IBM%20Data%20Server%20Driver%20Package

需先註冊成為IBM網站會員，註冊免費
沒有特殊需求請下載IBM Data Server Driver Package (DS Driver)

以下引自官網資料

Document Information

More support for:
IBM Data Server Client Packages

Software version:
11.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
387577

Modified date:
04 May 2022

TSQL利用CASE WHEN處理null值

 
因為有些欄位有null值，select出的資料整筆變成NULL

 

使用CASE WHEN去處理

 

 

 

gist
https://gist.github.com/imrexhuang/3715d6087e26f77577a1b5df937bb38b#file-tsql-case-when-null

 

sqlfiddle
http://sqlfiddle.com/#!18/5eba54/10