SQL Tutorial
SQL Database
SQL Table
SQL Select
SQL Clause
- sql-where
- sql-and
- sql-or
- sql-with
- sql-as
SQL Order By
SQL Insert
SQL Update
SQL Delete
SQL Join
SQL Keys
Difference
SQL Injection
- sql-injection
Misc
SQL MCQ
- sql-mcq
PL/SQL Tutorial
- pl/sql-tutorial
Interview
- sql-interview
- pl/sql-interview

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

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

SIR_NAME	NAME	MARKS
SINGH	RAMAN	5.5
JAISWAL	VICKY	6.2

Next Topic SQL WHERE Clause

< next>>

Hot Tutorials

HTML/CSS

JavaScript

Backend language

Development Framework

Database

Mobile development

Development tools

Big Data

XML Tutorial

Contact US

Email:jjw.quan@gmail.com

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

Difference

SQL Injection

Misc

SQL MCQ

PL/SQL Tutorial

Interview

SQL SELECT NULL

Note: we should not compare null value with 0. They are not equivalent.

Where SQL is NULL:

Where SQL is NOT NULL:

Hot Tutorials

Python tutorial

Vue.js Tutorial

HTML Tutorial

Java Tutorial

PHP Tutorial

Spring Tutorial

JavaScript Tutorial

CSS Tutorial

jQuery Tutorial

SQL Tutorial

C Tutorial

HTML/CSS

HTML Tutorial

HTML5 Tutorial

CSS Tutorial

Bootstrap Tutorial

JavaScript

JavaScript Tutorial

Vue.js Tutorial

ReactJS Tutorial

jQuery Tutorial

Node.js Tutorial

TypeScript Tutorial

AngularJS Tutorial

JSON Tutorial

Ajax Tutorial

ES6 Tutorial

Angular 7 Tutorial

jQuery UI Tutorial

Backend language

Python tutorial

Java Tutorial

Node.js Tutorial

PHP Tutorial

Go Tutorial

C Tutorial

C++ Tutorial

C# Tutorial

Ruby Tutorial

JSP Tutorial

JSTL Tutorial

ASP.NET Tutorial

Perl Tutorial

Scala Tutorial

VBA Tutorial

Development Framework

Spring Tutorial

Spring Boot Tutorial

Django Tutorial

Servlet Tutorial

Struts 2 Tutorial

Hibernate Tutorial

Solr Tutorial

Database

SQL Tutorial

MySQL Tutorial

Oracle Tutorial

SQL Server Tutorial