How to Work with Where Clause in SQL

In this article I am going to explain how to work with where clause.
  • 1683

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

Clipboard02.jpg


© 2020 DotNetHeaven. All rights reserved.