Search results
Example. Compare two expressions: SELECT NULLIF(25, 25); Try it Yourself » Definition and Usage. The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax. NULLIF (expr1, expr2) Parameter Values. Technical Details. More Examples. Example. Compare two expressions:
- Try It Yourself
Edit the SQL Statement, and click "Run SQL" to see the...
- The Try-SQLSERVER Editor
Edit the SQL Statement, and click "Run SQL" to see the...
- Try It Yourself
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
16 kwi 2009 · I need to calculate the number of FULL month in SQL, i.e. 2009-04-16 to 2009-05-15 => 0 full month; 2009-04-16 to 2009-05-16 => 1 full month; 2009-04-16 to 2009-06-16 => 2 full months; I tried to use DATEDIFF, i.e. SELECT DATEDIFF(MONTH, '2009-04-16', '2009-05-15')
The SQL NULLIF function is used to compare two expressions or values and return NULL if they are equal. It provides a way to handle specific cases where you want to treat equality as a special condition by substituting it with a NULL value.
The following example creates a budgets table, loads data, and uses NULLIF to return a null if current_year is null or contains the same data as previous_year.
Let's look at some SQL Server NULLIF function examples and explore how to use the NULLIF function in SQL Server (Transact-SQL). For example: SELECT NULLIF('TechOnTheNet.com', 'TechOnTheNet.com'); Result: NULL (returns NULL because values are the same) SELECT NULLIF('CheckYourMath.com', 'TechOnTheNet.com'); Result: 'CheckYourMath.com' (returns ...
8 maj 2022 · Example. Here’s an example to demonstrate: SELECT NULLIF( 12, 12 ); Result: NULL. In this case, both arguments are identical and so the result is NULL. Depending on your RDBMS, the actual output for NULL values may be different.
