programplug Logo



SQL Null Value

SQL;



SQL Basic

» SQL Introduction

» What is SQL?

» What is RDBMS?

» Syntax In SQL

» Data Type In SQL

» Operators In SQL

» Truncate

SQL Table

» Table

» Table Variable

» Create Table

» Copy Table

» Alter Table

» Drop Table

SQL Commands

» Commands In SQL

» Create Statement

» Select Statement

» Delete Statement

» Drop Database

SQL Clause

» WHERE Clause

» AND Clause

» OR Clause

» WITH Clause

SQL Keys

» Primary Key

» Foreign Key

» Unique Key

»Null Value

» Not Null Value

SQL Joins

» Joins

» Inner

» Full

» Left

» Right

SQL Order

» Order By

NULL VALUE



The NULL VALUE is the term which represent a missing value. A NULL value in a table is a value which appears to be blank.

Syntax: 
SELECT column_name
FROM table_name
WHERE column_name IS NULL;
Example:
c_id c_name c_age c_experince
01 Frank 37 7
02 Lennin 27
03 andy 41 6
04 Peter 29 3
05 Mike 44 
SELECT  c_id,c_name, c_age,c_experince
FROM Teacher
WHERE Experience IS NOT NULL;
c_id c_name c_age c_experince
02 Lennin 27
05 Mike 44