Where clause in MS SQL Server

In this article, where clause will be discussed alongside example.

Introduction :

1. To extract the data at times, we need a particular conditions to satisfy.
2. ‘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.

My Personal Notes arrow_drop_up

Save