What is the WHERE clause?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the WHERE clause?
Rating:
The WHERE clause is used to determine the values that will be returned in the resultset. It specifies a condition, and the records that satisfy the given condition are returned in the resultset. In other words, the WHERE clause restricts the number of rows retrieved from the table. For example:
FROM Table
WHERE Empage>50
Here, all the records where Empage is greater than 50 will be extracted from the table named Table.
Rating:
Was this information helpful?
Other articles
- What is synchronous call?
- What is Memory Manager (MMAN)?
- What is the Memory Advisor?
- MCSD .NET/MCAD .NET/MCDBA 70-305 Short Notes: Exam Passing Tips
- What is the Locals window?