programplug Logo



SQL Not 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

NOT NULL VALUE


Syntax: 
SELECT  c_id,c_name, c_age,c_experince
FROM Teacher
WHERE Experience IS NOT 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
Result:
c_id c_name c_age c_experince
01 Frank 37 7
03 andy 41 6
03 andy 41 6
04 Peter 29 3