Search results
The NULLIF() function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax
- 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
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.
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
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.
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.
25 sie 2021 · NULLIF. To save yourself from division by 0 errors: SELECT last_month, this_month, this_month * 100.0 / NULLIF(last_month, 0) AS better_by_percent FROM video_views; The NULLIF(x, y) function will return NULL if x is the same as y, else it will return the x value.
8 maj 2022 · SQL NULLIF () Explained. Most major RDBMS s support the NULLIF() operator, which returns NULL if both of its arguments are equivalent. If the arguments not equivalent, NULLIF() returns the first argument. NULLIF() is a SQL-standard feature (it’s included in the ISO/IEC 9075 specification).
