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:

  1. Where SQL is NULL
  2. 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_NAMENAMEMARKS
TYAGISEEMA
SINGHRAMAN5.5
SHARMAAMAR
JAISWALVICKY6.2

Let's see the query to get all the records where marks is NULL:

It will return the following records:

SIR_NAMENAMEMARKS
SHARMAAMAR
TYAGISEEMA

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

SIR_NAMENAMEMARKS
SINGHRAMAN5.5
JAISWALVICKY6.2