Home / mySQL / AND and OR Operators – SQL

AND and OR Operators – SQL

Hi Guys,
Today we share our idea related to AND and OR operator with example.
The AND and OR operators are the conditional operator in SQL. It is used to filter the data or records based on conditions. The main difference between AND and OR operators are: the AND operator displays a record if both the first condition AND the second condition are true and the OR operator displays a record if either the first condition OR the second condition is true.



The AND Operator

The AND operator use in SQL statement’s WHERE clause in SELECT query. It allows the existence of multiple conditions in an SQL statement’s WHERE clause.

Syntax:

The basic syntax of AND operator with WHERE clause is as follows:

SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] AND [condition2]…AND [conditionN];




We can combine N number of conditions using AND operator.The AND operator displays a record if both the first condition AND the second condition are true

Example using AND operator. Consider following Employee table




Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Arathy 10000
5 Ashwathi 8000

SQL query selects all Employee from the Employee_name “Ashwathi” AND the salary “8000”, in the “Employee” table:




SELECT * FROM Employee
WHERE Employee_name=’Ashwathi’
AND salary=8000;;

Result of the above query will be,

Employee_id Employee_name salary
5 Ashwathi 8000




The OR Operator

The OR operator use in SQL statement’s WHERE clause in SELECT query. It allows the existence of multiple conditions in an SQL statement’s WHERE clause.

Syntax

The basic syntax of OR operator with WHERE clause is as follows:

SELECT column1, column2, columnN
FROM table_name
WHERE [condition1] OR [condition2]…OR [conditionN]




We can combine N number of conditions using OR operator.The OR operatordisplays a record if either the first condition OR the second condition is true.

Example using OR operator. Consider following Employee table




Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Arathy 10000
5 Ashwathi 8000

SQL query selects all Employee from the Employee_name “Ashwathi” OR the Employee_name “Achu”, in the “Employee” table:

SELECT * FROM Employee
WHERE Employee_name=’Ashwathi’
OR Employee_name=’Achu’;;

Result of the above query will be,

Employee_id Employee_name salary
3 Achu 6000
5 Ashwathi 8000




Combining AND & OR

You can also combine AND and OR operator.

Example using Combining AND and OR operator. Consider following Employee table




Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Arathy 10000
5 Ashwathi 8000

SQL query selects all Employee from the Employee_name “Ashwathi” AND the salary “8000” or salary ‘10000’ in the “Employee” table:




SELECT * FROM Employee
WHERE Employee_name=’Ashwathi’ AND(salary=8000 OR salary=10000);

Result of the above query will be,

Employee_id Employee_name salary
5 Ashwathi 8000




Example2 using Combining AND and OR operator. Consider following Employee table




Employee_id Employee_name salary
1 Appu 9000
2 Ammu 8000
3 Achu 6000
4 Ashwathi 10000
5 Ashwathi 8000

SQL query selects all Employee from the Employee_name “Ashwathi” OR the Employee “Achu”, in the “Employee” table:

SELECT * FROM Employee
WHERE Employee_name=’Ashwathi’ AND(salary=8000 OR salary=10000);

Result of the above query will be,

Employee_id Employee_name salary
4 Ashwathi 10000
5 Ashwathi 8000




If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Loading Facebook Comments ...
Social Media Auto Publish Powered By : XYZScripts.com