In this example, you can test the Salary column for null.
SELECT empno, ZEROIFNULL(salary) FROM employee ;
A nonzero value is returned for each employee number, indicating that no nulls exist in the Salary column.
In this example, you can test the Salary column for null.
SELECT empno, ZEROIFNULL(salary) FROM employee ;
A nonzero value is returned for each employee number, indicating that no nulls exist in the Salary column.