NOT Condition



SQLite: NOT Condition

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


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


Parameters or Arguments:


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.


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