Introduction to Where clause: In the where clause use to include a condition while fetching data from tables. It is also used to join multiple tables. Not only used with select statement, also used with update and delete queries. Now given bellow the example code:
select * from Salary where Salary.Gendar='male' select * from Salary where Salary.Id=3
There are two examples first we get the all value from salary table which gender are ‘male’ then second query is getting one recode from salary table which id is ‘3’. In this salary table Id is primary key.