Where clause in MS SQL Server
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.
Last Updated :
09 Jun, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...