Javatpoint Logo
Javatpoint Logo

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
Next TopicSQL WHERE Clause




Please Share

facebook twitter google plus pinterest tumbler

Learn Latest Tutorials