The SQL “NOT” clause is used with “WHERE” conditions.
The “AND”, “OR” and “NOT” operators are used to test two or more conditions in a SELECT, INSERT, UPDATE, or DELETE statements.
The “WHERE” clause with “AND” operator requires that two conditions are true and an “OR” requires that one of two conditions is true and the “NOT” negates the specified condition.
Stayed Informed - 37 Best SQL Server Interview Questions and Answers
Syntax:-
--THE WHERE WITH AND OPERATOR
SELECT ColumnName, ColumnName
FROM TableName WHERE Condition1 AND Condition2
--THE WHERE WITH OR OPERATOR
UPDATE TableName
SET ColumnName = value
WHERE Condition1 OR Condition2
--THE WHERE WITH NOT OPERATOR
DELETE TableName
WHERE NOT Condition1
Examples:-
--SELECT ALL COUNTRIES
SELECT [Id]
,[CountryName]
,[CountryCode]
FROM [test].[dbo].[Countries]
Result:-
Id CountryName CountryCode
-------------------------------------
1 India IN
2 Nepal NP
3 USA US
4 Rasia NULL
5 Australia AUS
Example :-
-- SELECT ALL MATCHED CONDITIONS COUNTRIES
SELECT [Id]
,[CountryName]
,[CountryCode]
FROM [test].[dbo].[Countries]
WHERE (CountryCode = 'IN' AND Id 2) OR (CountryCode = 'US' AND Id 2)
Result :-
Id CountryName CountryCode
-----------------------------------
1 India IN
3 USA US
Stayed Informed - SQL Server Query and Examples
I hope you are enjoying with this post! Please share with you friends. Thank you!!
