SQL SELECT NULL

When working with databases, handling NULL values is essential. But before we dive into queries, let’s first understand what NULL means in SQL.

Complete Python Course with Advance topics:-Click Here
SQL Tutorial :-Click Here

What is NULL in SQL?

NULL values represent missing or unknown data in a table. A column can have NULL values when data is not provided during insertion or updating.

Note: NULL is not the same as 0 or an empty string (“”).

There are two conditions we commonly use in SQL:

1. WHERE column IS NULL → To find records where a specific column has NULL values.
2. WHERE column IS NOT NULL → To find records where a column has actual data (not NULL).

1. WHERE SQL IS NULL

How to select records with NULL values in a specific column?

Let’s consider a STUDENTS table:

SIR_NAME	NAME	MARKS
VERMA	RAHUL	NULL
MISHRA	ANKITA	7.5
SINGH	ROHAN	NULL
SHARMA	NEHA	8.3

To retrieve all records where the MARKS column is NULL, use the following query:

SELECT SIR_NAME, NAME, MARKS FROM STUDENTS  
WHERE MARKS IS NULL;  

Output:

SIR_NAME	NAME	MARKS
VERMA	RAHUL	NULL
SINGH	ROHAN	NULL

2. WHERE SQL IS NOT NULL

How to select records that do not have NULL values?

To get all the records where MARKS is NOT NULL, use the following query:

SELECT SIR_NAME, NAME, MARKS FROM STUDENTS  
WHERE MARKS IS NOT NULL;  

Output:

SIR_NAME	NAME	MARKS
MISHRA	ANKITA	7.5
SHARMA	NEHA	8.3

Download New Real Time Projects :-Click here
Complete Advance AI topics:- CLICK HERE

Conclusion

Handling NULL values properly is crucial in SQL. IS NULL helps filter out missing data, while IS NOT NULL ensures only complete records are retrieved.

For more professional SQL tutorials, stay tuned to UpdateGadh! 🚀

---

sql select null if not exists
sql select null as column
sql select null as 0
sql select null as blank
sql select null as empty string
sql select query for null
sql select not null and not empty
sql select statement with null
sql query select not null columns
sql where not null or empty
sql is null or empty
how to check if any column has null value in sql
sql select null values
sql select null w3schools
sql select null oracle
how to include null values in sql where clause