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
| Roll number |
Name |
Course |
| 111 |
Riya |
CSE |
| 112 |
Apoorva |
ECE |
| 113 |
Mina |
Mech |
| 114 |
Rita |
Biotechnology |
| 115 |
Veena |
Chemical |
| 116 |
Deepa |
EEE |
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.
