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
Example
The Above Query Will Fetch the results :
Example 2 – : Fetch The Results where user’s ID is ‘5’
Example
The Above Query Will Produce the result as :
Advertisements
Add Comment
📖 Read More
- 1. SQL - AND & OR
- 2. SQL ORDER BY
- 3. SQL - UPDATE
- 4. SQL - DELETE
- 5. SQL - Like
- 6. SQL In Operator
- 7. SQL Between
- 8. SQL Joins - INNER JOIN
- 9. SQL - LEFT JOIN
- 10. SQL - RIGHT JOIN