Sql Query To Use a ' SELECT ' statement with OR Operator

To use two or more conditions to retrieve, insert, update and delete records from the existing created table. And from this, anyone condition have to meet. Then we can use a ' WHERE ' statement with OR conditions.

In this statement, it will retrieve the first_name start with specific syntax “su” or employee_id is greater than 150 from the table employees.

In this, anyone conditions (first_name LIKE “su%”) or (employee_id>150) will be met.

Note- OR Condition not only used in SELECT but also INSERT, UPDATE and DELETE.

Database

Theme

Enter - Select * from table_name;

Output

Similar Program

#	Program	Language
1	Sql Query To Use a ' SELECT ' statement with HAVING Clause	SQL
2	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
3	Sql Query To Use a ' SELECT ' statement with LIMIT	SQL
4	Sql Query To Use a ' SELECT ' statement with SUM() function.	SQL
5	Sql Case Sensitive Query Without Semicolon	SQL
6	Sql Query to Delete Records	SQL
7	Sql Query To use CHECK Constraint	SQL
8	Sql Query to use a Not Null Constraint	SQL
9	Sql Query To Drop Table	SQL
10	Sql Query To Insert Multiple Records At A Time In The Table	SQL
11	Sql Case Sensitive Example 4	SQL
12	Sql Case Sensitive Example 1	SQL
13	Sql Query To Use a Inner Joins	SQL
14	Sql Query To Use a ' SELECT ' statement with the MIN() or MAX() function.	SQL
15	Sql Case Sensitive Example 3	SQL
16	Sql Query To Retrieve Record Using Where Condition	SQL
17	Sql Query To Use a ' SELECT ' statement with Alias or 'AS"	SQL
18	Sql Update Query Without Where Condition	SQL
19	Sql Query to retrieve data using Order By in Random Order	SQL
20	Sql Query To Use a ' SELECT ' statement with LIKE Clause	SQL
#	Program	Language

Sql Query To Use a ' SELECT ' statement with OR Operator

Similar Program

About Fresherbell

Important Links

Social Media