Search results
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: SELECT NULLIF('Hello', 'Hello'); Try it Yourself » 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
25 sie 2021 · This comprehensive cheat sheet is packed with syntax for different text and numeric functions, CASE WHEN statements, handling NULL, date and time types, INTERVAL s, and aggregate functions. It also features a troubleshooting section to help you navigate through common issues seamlessly. Download Options:
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
22 sty 2014 · SELECT RecordId, MIN(StartDate), NULLIF(MAX(COALESCE(EndDate,'9999-12-31')),'9999-12-31') FROM tmp GROUP BY RecordId Per your fiddle this will return the exact results you specify under all conditions.
NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. Remarks. NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL.
You would use the SQL NULLIF function when you want to replace a value with NULL in your query result if it matches a specified condition. NULLIF is particularly useful when you need to handle equality as a distinct case, such as when you want to hide or suppress certain results in your query.
Summary: in this tutorial, you will learn how to use the SQL Server NULLIF expression to return NULL if the first argument equals to the second one. The NULLIF expression accepts two arguments and returns NULL if two arguments are equal.
