Using NOT operator to inverse the condition in SQL Server

Published on August 16, 2016 by Senthil Kumar

Filed under SQL Server

Last modified August 16, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 7102 times

Imagine a scenario where you want to retreive records that you dont want. You can use the NOT operator to reverse the search condition.

For example , You want to get all the departments having the GroupName other than ‘Research and Development’.

SELECT * FROM HumanResources.Department
where NOT ( GroupName = 'Research and Development' )


The other way of getting the same result is using the != in every condition.

SELECT * FROM HumanResources.Department
where  GroupName != 'Research and Development'

Leave a Comment


You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...