In this article, we are going to use the table Employee for explaining examples. Structure of this table is given below:-
CREATE TABLE [dbo]. [Employee](
[Empid] [Int] IDENTITY (1, 1) NOT NULL Primary key,
[EmpNumber] [nvarchar](50) NOT NULL,
[EmpFirstName] [nvarchar](150) NOT NULL,
[EmpLAStName] [nvarchar](150) NULL,
[EmpEmail] [nvarchar](150) NULL,
[Salary] [int] NULL
)
Following Insert queries will insert data into the table Employee
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A001′,’Vivek’,’Johari’,’samir@abcmail.com’,200000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A002′,’Amit’,’Kumar’,’amit@abcmail.com’,100000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A003′,’Neha’,’Sharma’,’neha@abcmail.com’,300000)
Insert Into Employee (EmpNumber,EmpFirstName,EmpLAStName,EmpEmail,salary)
Values(‘A004′,’Nidhi’,’Sharma’,’nidhi@abcmail.com’,270000)
For example, in case of “AND”, suppose we want to get records from the table Employee whose last name is “Sharma” and salary less than 300000, then we can use the following query:-
Select * from employee where EmpLastName=’Sharma’ AND salary < 300000
This query will return the record of the employee whose empnumber is “A004”.
In case of “OR”, suppose we want to get records from the table Employee whose last name is either Sharma or salary is less than 300000, then we can use the following query
Select EmpNumber from employee where EmpLastName=’Sharma’ OR salary < 300000
This query will returns all the records:-
A001
A002
A003
A004
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
… [Trackback]
[…] Information to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Here you will find 57468 more Information on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] There you will find 83551 additional Info on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More Info here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] There you will find 2244 more Info to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] There you can find 34823 additional Information on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More here to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2014/08/and-and-or-operator-in-sql-server.html […]