SQL OR Operators

The OR operator displays records if any of the conditions is true.

1st Condition	2nd Condition	Result
false	false	false
false	true	true
true	false	true
true	true	true

Understand with Example

The Tutorial illustrate an example from SQL OR Operator .In this we help you to know the use of 'OR' Operator. For this we create a table Stu_Table with the help of create statement.

Create Table Stu_Table

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class  varchar(10))

Insert data into Stu_Table

The insert into add the records or rows to the table Stu_Table.

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',11);
insert into Stu_Table values(4,'Bhanu',11);
insert into Stu_Table values(5,'Santosh',12);
insert into Stu_Table values(1,'Komal',10);

Stu_Table

The select statement help you to display the table detail.

Stu_Id	Stu_Name	Stu_Class
1	Komal	10
2	Ajay	10
3	Rakesh	11
4	Bhanu	11
5	Santosh	12
1	Komal	10

SQL OR Operator Syntax

The SQL OR Operator is used to return a record if either the first condition is true or the second condition is true. The Syntax used for SQL OR Operator is given below:

SELECT columnName(s)
FROM tableName
where condition1 OR conditions2

SQL OR Operator Query

In this example, we make use of OR Operator, which return the records from a table on the basis of condition in WHERE Clause. The OR Operator return you a set of records,if either of the condition are true.

SELECT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table
where Stu_Id = 1 OR Stu_Class = 10

Result

Stu_Id	Stu_Name	Stu_Class
1	Komal	10
2	Ajay	10
1	Komal	11

SQL OR Operators

SQL OR Operators

Spring Framework Training

R Programming Training

SQL OR Operators