Where clause in MS SQL Server
In this article, where clause will be discussed alongside example.
- 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.
select select_list from table_name where condition
A example is given below for better clarification –
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.