SQL Tip: COALESCE -

The COALESCE function returns the value of the first nonnull expression

Solved: my query is as below select _ID, _ID, coalesce as REDUNDANT_STOCK_ID from STOCK_ARRIVAL SA

coalesce synonyms To include the NULL values in the calculation of MAX, we can use the COALESCE function to replace the NULL values with a default value (such

coalesce db2 Description COALESCE accepts a comma separated list of parameters and returns the first value that is not null in that list or null if all the arguments are