SQL OR

SQL OR clause is used to select data when any of the two conditions are met.

The syntax of SQL OR clause is

SELECT columns
FROM table
WHERE condition1 OR condition2;

 

SQL OR is executed when any of the both conditions are met.

Example:

Let us take a Student Table.

StudentID Student_Name Address City
1 Nithin Bank Street Hyderabad
2 Bharath White Field Bangalore
3 Goutham Avenue colony Chennai
4 Bhargav James street Chennai
5 Varun Park Avenue Chennai


Now we select the data where the Student City is Hyderabad or Addre