In the previous chapter we have learn how to filter record using where clause using one condition.
In this chapter we are going to learn how to filter record using where clause using more than one condition.
And or not operator used in where clause to write more than one condition.
And is a logical operator used to combines more than one conditions and returns TRUE if all condition is TRUE otherwise it return FALSE .
SELECT column1_name, column2_name,...
FROM table_name
WHERE condition1 AND condition2...;
Similarly OR is a logical operator used to combines more than one conditions .But it returns TRUE if one of the condition is TRUE otherwise it return FALSE .
SELECT column1_name, column2_name, ...
FROM table_name
WHERE condition1 OR condition2...;
The NOT operator used to fetch record if the condition is not satisfy.
SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;