SQL SELECT NULL
First of all we should know that what null value is? Null values are used to represent missing unknown data.
There can be two conditions:
- Where SQL is NULL
- Where SQL is NOT NULL
If in a table, a column is optional, it is very easy to insert data in column or update an existing record without adding a value in this column. This means that field has null value.
Note: we should not compare null value with 0. They are not equivalent.
Where SQL is NULL:
How to select records with null values only? (in the marks column)
There is an example of student table:
| SIR_NAME | NAME | MARKS |
|---|---|---|
| TYAGI | SEEMA | |
| SINGH | RAMAN | 5.5 |
| SHARMA | AMAR | |
| JAISWAL | VICKY | 6.2 |
Let's see the query to get all the records where marks is NULL:
SELECT SIR_NAME, NAME, MARKS FROM STUDENTS
WHERE MARKS IS NULL
WHERE MARKS IS NULL
It will return the following records:
| SIR_NAME | NAME | MARKS |
|---|---|---|
| SHARMA | AMAR | |
| TYAGI | SEEMA |
Where SQL is NOT NULL:
How to select records with no null values(in marks column)? Let's see the query to get all the records where marks is NOT NULL
SELECT SIR_NAME, FIRSTNAME, MARKS FROM STUDENTS
WHERE MARKS IS NOT NULL
WHERE MARKS IS NOT NULL
| SIR_NAME | NAME | MARKS |
|---|---|---|
| SINGH | RAMAN | 5.5 |
| JAISWAL | VICKY | 6.2 |
