In this article, where clause will be discussed alongside example.
Introduction :
- To extract the data at times, we need a particular conditions to satisfy.
- 'where' is a clause used to write the condition in the query.
Syntax :
select select_list
from table_name
where condition
A example is given below for better clarification -
Example :
Sample table: Student
If a user wants to extract the name of the student who is pursuing Mechanical, the query is as follows:
select name
from student
where course='Mechanical'
The output is -
'where' condition filters only the rows that are evaluated to true. If the condition evaluates to false or unknown, the rows will not be filtered causing an error.
