SQL AND & OR Operators

SQL AND & OR Operator Syntax

For AND only condition:

SELECT column_name1, column_name2 FROM table_name 
WHERE [condition1] AND [condition2];

For OR only condition:

SELECT column_name1, column_name2 FROM table_name 
WHERE [condition1] OR [condition2];

For AND & OR both condition:

SELECT column_name1, column_name2 FROM table_name 
WHERE ([condition1] AND [condition2]) OR [condition3];

or

SELECT column_name1, column_name2 FROM table_name 
WHERE ([condition1] OR [condition2]) AND [condition3];

Note: You can combine multiple conditions using both operators. When combining these conditions in a sql statement, it is very important to provide round brackets or parenthesis so that the database engine knows what order to operate each condition.

Sample Database Table - Books

SQL AND Operator Example

The following SQL SELECT statement selects all the books from the domainname "Database" AND bookprice greater then "100", in the "Books" table:

SELECT * FROM Books 
WHERE 
DomainName = 'Database' AND BookPrice > 100;

The result of above query is:

SQL OR Operator Example

The following SQL SELECT statement selects all the books from the authorname "Azaghu Varshith" OR "Padmavathi", in the "Books" table:

SELECT * FROM Books 
WHERE 
AuthorName = 'Azaghu Varshith' OR AuthorName = 'Padmavathi';

The result of above query is:

Combining SQL AND & OR Operator Example

You can also combine AND and OR operators using round brackets or parenthesis to form complex expressions.

The following SQL statement selects all books from the book year less than "170" AND the domain name must be equal to "Programming" OR "Security", in the "Books" table:

SELECT * FROM Books 
WHERE 
BookPrice < 170 AND (DomainName = 'Programming' OR DomainName = 'Security');

The result of above query is:

Note: Don't forget to provide round brackets on conditions based on your need.

It is very important to provide round brackets or parenthesis so that the database engine knows what order to operate each condition.

If we did not provide the round brackets, it will change the condition execution order.

SELECT * FROM Books 
WHERE 
BookPrice < 170 AND DomainName = 'Programming' OR DomainName = 'Security';

The result of above query is: