DB2 COALESCE() - CSDN文库

2 Oracle and DB2 Compared coalesce db2 DB2) Basic difference between COALESCE and their counter parts is that COALESCE returns first non null value as it can take more than 2 coalesce db2 The DB2 COALESCE function returns the value of the first non-NULL expression The COALESCE function takes a comma separated list of arguments which are

coalesce معنى Solved: my query is as below select _ID, _ID, coalesce as REDUNDANT_STOCK_ID from STOCK_ARRIVAL SA