How to Work with Where Clause in SQL
In this article I am going to explain how to work with where clause.
Introduction
In this article I am going to explain how to work with where clause in SQL. WHERE clause in SQL is used to filter records. We use it to find the specific record into result set from table stored in database. It is used to fetch specific row or specific record.
Example
SELECT * FROM dbo.mcnemp
WHERE age > 20
|
Output