MySQL | Documentation | MySQL | By chapter | Page

Create a SQL query that displays the salary or a zero if there is no salary of all employees. SELECT NVL(salary, 0) List and describe the two IF-THEN-ELSE logic methods? Give an example of each. CASE – ANSI SQL complied of an if-then-else logic method. DECODE – ORACLE specific of an if … ................
................