SQL Server - OR Operator

The SQL Server (Transact-SQL) OR Operator is used to combine multiple conditions in a WHERE clause of SQL Server statement. It displays a record if any the conditions separated by OR operator is true.

Syntax

The syntax for using OR operator in SQL Server (Transact-SQL) is given below:

SELECT column1, column2, column3, ...
FROM table_name
WHERE condition1 OR condition2 OR condtion3 ....;

Example:

Consider a database containing table called Employee with the following records:

• To select all records of the Employee table where Salary is greater than 2800 or Age is less than 25, the query is given below.

  SELECT * FROM Employee
  WHERE Salary > 2800 OR Age < 25;
  

  
  

  This will produce the result as shown below:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3000
  2	Marry	New York	24	2750
  4	Kim	Amsterdam	30	3100
  5	Ramesh	New Delhi	28	3000