MySQL IFNULL() Nested Function Example

MySQL IFNULL() Nested Function Example

Open your MySQL Query Editor then copy & paste the below code to get the value of IFNULL() MySQL Nested Function Example:

   --
   SELECT IFNULL(1,11), IF(IFNULL(1,11)>10,10,NULL), IFNULL(IF(IFNULL(1,11)>10,10,NULL),99);
   --

   -- MySQL IFNULL() Function Deals With Two Expressions
   --
   -- if    [Expression1/Value1] evaluates to NULL, returns [Expression2/Value2]
   -- else  [Expression1/Value1]

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

MySQL IFNULL() Nested Function Example - Result in MySQL Query Editor

 

Related Tutorial Examples

  1. MySQL IFNULL() Function Datetime Example
  2. MySQL IFNULL() Function String Example
  3. MySQL IFNULL() Function Number Example
  4. MySQL IFNULL() Function Boolean Example
  5. MySQL IFNULL() Function NULL Value Example
  6. MySQL NULLIF() Function NULL Value Example
  7. MSSQL PRINT Like Function in MySQL Example
  8. SELECT specific columns using SQL Command MySQL Example
  9. SELECT distinct... SQL Command MySQL Example
  10. SELECT specific row(s) of a Table using SQL Command MySQL Example

No comments:

Post a Comment

leave your comments here..