3rd highest salary in sql server

SQL WHERE AND, OR, NOT Clause [SQL Operators]

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.


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!!
ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book