Latest Post

Friday, 16 September 2016

OR Sql Operator (Keyword)

OR
The OR is logical operator and used to filter the records on one or more condition.
Syntax: The following is the basic syntax of AND keyword
SELECT column1, column2 FROM your_table_name WHERE Condition1 OR Condition2
Example:

Id
Name
Age
Address
Department
Gender
1
Alok Kumar Singh
30
IN
IT
Male
2
Tomas Paul
45
NZ
IT
Male
3
Cristomfer Dee
24
AU
HR
Female
4
Niel Macengi
55
US
BPO
Female

The following SQL statement selects all employee of "IT" department or "BPO" department
USE SQLCLR
GO
  SELECT * FROM EMPLOYEE WHERE Department='IT' OR Department='BPO'

GO
Id
Name
Age
Address
Department
Gender
1
Alok Kumar Singh
30
IN
IT
Male
2
Tomas Paul
45
NZ
IT
Male
4
Niel Macengi
55
US
BPO
Female






Government Jobs