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
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.
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
16 mar 2024 · SQL provides several functions to handle these values more gracefully, allowing for cleaner data presentation and more robust calculations. In this article, we'll explore how to use ISNULL, NULLIF, and COALESCE with practical examples.
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.
The NULLIF expression comes in handy when you’re working with legacy data that contains a mixture of null and empty strings in a column. Consider the following example. First, create a new table named sales.leads to store the sales leads:
21 mar 2022 · In this SQL tutorial, we have reviewed the SQL (structured query language) functions COALESCE(), ISNULL(), NULLIF() and how these work in SQL Server, Oracle and PostgreSQL. There are also other ways for checking NULL values such as the IS NULL clause and there are other complex functions in Oracle.
