NOT Condition


 

 

SQLite: NOT Condition

This SQLite tutorial explains how to use the SQLite NOT Condition with syntax and examples.

 

Description:
The SQLite NOT Condition (also called the NOT Operator) is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement.
Syntax:

 

Parameters or Arguments:

condition

The condition to negate.

Note: The SQLite NOT condition requires that the opposite of the condition be must be met for the record to be included in the result set.

 

Examples:
The following SQLite statement return all rows from the employees table where the position is not ‘developer’:

id name position hire_date
101 arunesh manager 1/1/2012
102 naga Team Lead 1/1/2013
105 uma designer 1/1/2013
106 mathu research analyst 1/1/2013
107 anitha research analyst 1/1/2014
108 kannan 6/1/2013