WHERE Clause Example in SQL Server

WHERE Clause Example in SQL Server

The WHERE clause is used to find only those records that fulfill a specified condition.

Syntax:

SELECT column1, column2,column3, ........
FROM table_name
WHERE condition

Example:

SELECT * FROM Customers
WHERE CustomerID=100
SELECT * FROM Customers
WHERE Country='India'

2020-03-27