SQL NOT Operator - The Coding Shala

Home >> Learn SQL >> SQL NOT Operator

SQL NOT Operator

The SQL 'NOT' Operator displays records if the condition is not true.

SQL NOT Operator Syntax

The basic syntax of SQL NOT Operator is as follows - 

SELECT column1, column2, ...  
 FROM table_name  
 WHERE NOT condition;

SQL NOT Operator Examples 

The following 'emp' table will be used for the examples - 

Id     Name     Age     Address     Salary  
 1     Akshay     22     Pune        40000  
 2     Mohit      21     Delhi       42000  
 3     Akash      21     Delhi       45000  
 4     Nikhil     24     Mumbai      50000  
 5     Smith      24     Pune        50000  
 6     Akshay     22     Pune        50000  
 7     Nikhil     24     Mumbai      43000 

The following query will return records if Name is not Akshay - 

 SQL >> select * from emp   
       where NOT Name = 'Akshay';  
 
Output >>   
 Id     Name     Age     Address     Salary  
 2     Mohit      21     Delhi      42000  
 3     Akash      21     Delhi      45000  
 4     Nikhil     24     Mumbai     50000  
 5     Smith      24     Pune       50000  
 7     Nikhil     24     Mumbai     43000 

Other Posts You May Like

• SQL Union Clause
• SQL IN Operator
• SQL Between Operator
• SQL Count() function
• SQL sum() function

Prev<< SQL OR Operator                                                                   NEXT >>SQL Wildcard Operator

Please leave a comment below if you like this post or found some error, it will help me to improve my content.