SQL OR

The SQL OR condition is used in SQL query to create a SQL statement where records are returned when any one condition met. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement.

Let's see the syntax for the OR condition:


IDFirst_NameLast_NameDepartmentLocation
1HarshadKuwarMarketingPune
2AnuragRajputITMumbai
3ChaitaliTarleITChennai
4PranjalPatilITChennai
5SurajTripathiMarketingPune
6RoshniJadhavFinanceBangalore
7SandhyaJainFinanceBangalore
  • SQL "OR" example with SQL SELECT

This is how an SQL "OR" condition can be used in the SQL SELECT statement.

Example 1:

Write a query to get the records from emp tables in which department of the employee is IT or location is Chennai.

Query:


IDFirst_NameLast_NameDepartmentLocation
2AnuragRajputITMumbai
3ChaitaliTarleITChennai
4PranjalPatilITChennai

In the emp table, there are three employees whose department is IT. But there are only two records whose location is Chennai. Still, all three records are displayed. This happened because we have specified OR operator in the query, according to which the record will be considered in the result set even any one condition is met.

Example 2:

Write a query to get the records from emp tables in which department of the employee is Marketing or location is Noida.

Query:


IDFirst_NameLast_NameDepartmentLocation
1HarshadKuwarMarketingPune
5SurajTripathiMarketingPune
7SandhyaJainFinanceBangalore

There are two employees whose department is Marketing in the emp table, but still, three records are displayed. This happened because of the use of the OR operator in the query. Among the three records displayed above, the first two records satisfy condition 1; the second record satisfies both the conditions and the third record satisfies only condition 1. Due to the OR operator, even if anyone condition is satisfied, the record is considered in the result-set.

  • SQL "OR" example with SQL UPDATE

This is how the "OR" condition can be used in the SQL UPDATE statement.

Example 1:

Write a query to update the records in emp tables in which department of the employee is Marketing, or the last name is Tarle. For that particular employee, set the updated value of the location as Delhi.

Query:


SQL OR

We will use the SELECT query to verify the updated record.


IDFirst_NameLast_NameDepartmentLocation
1HarshadKuwarMarketingPune
2AnuragRajputITMumbai
3ChaitaliTarleITChennai
4PranjalPatilITChennai
5SurajTripathiMarketingPune
6RoshniJadhavFinanceBangalore
7SandhyaJainFinanceBangalore

There are two employees whose department is 'Marketing' and one record whose last name is 'Tarle' in the emp table. Though only one condition is still met, that record is considered and updated in the table due to the OR operator.

Example 2:

Write a query to update the records in the emp table in which department of the employee is Finance, or the first name is Sandhya. For that particular employee, set the updated value of the department as HR.

Query:


SQL OR

We will use the SELECT query to verify the updated record.


IDFirst_NameLast_NameDepartmentLocation
1HarshadKuwarMarketingDelhi
2AnuragRajputITMumbai
3ChaitaliTarleITDelhi
4PranjalPatilITChennai
5SurajTripathiMarketingDelhi
6RoshniJadhavHRBangalore
7SandhyaJainHRNoida

There are two employees whose department is 'Finance,' and among these two records, one record satisfies both the conditions in the emp table. However, both the records are considered and updated in the table due to the OR operator.

  • SQL "OR" example with SQL DELETE

This is how an SQL "OR" condition can be used in the SQL DELETE statement.

Example 1:

Write a query to delete the records from the emp table in which the last name of the employee is Jain or Location is Bangalore.

Query:


SQL OR

We will use the SELECT query to verify the deleted record.


IDFirst_NameLast_NameDepartmentLocation
1HarshadKuwarMarketingPune
2AnuragRajputITMumbai
3ChaitaliTarleITChennai
4PranjalPatilITChennai
5SurajTripathiMarketingPune

There is only one record in the emp table whose last name is Jain and one record whose location is Bangalore. But still, due to the presence of an OR operator, even if anyone condition is satisfied, that particular record is deleted.

Example 2:

Write a query to delete the records from the emp table in which department of the employee is marketing and Location is Delhi.

Query:


SQL OR

We will use the SELECT query to verify the deleted record.


IDFirst_NameLast_NameDepartmentLocation
2AnuragRajputITMumbai
4PranjalPatilITChennai

There is only one record in the emp table whose department is Marketing and one record whose location is Delhi. But still, due to the presence of an OR operator, even if anyone condition is satisfied, that particular record is deleted.


Next TopicSQL WITH




Latest Courses