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 –
Name | Course |
---|---|
Mina | Mech |
‘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.
Contact Us