SQL – WHERE Clause
SQL WHERE Clause
SQL WHERE Clause is used to filter the recoreds on the basis of some condition.
This will fetch the results which will fullfill the condition specified.
SQL WHERE Syntax :
Suppose The “Users” Table has following records :
Suppose we have to find those records which have ‘city’ value as “DELHI”
Example 1 – : The Following Example will fetch the results as
The Above Query Will Fetch the results :
Example 2 – : Fetch The Results where user’s ID is ‘5’
The Above Query Will Produce the result as :