SQL Server Transact Basic to Expert - Select Query using basic Where condition

This blog shows on how to use a where condition with the select condition. WHERE clause is used in cases where we need to fetch data based on the condition satisfy

Syntax:

SELECT Column_List
FROM Table
WHERE Condition_List

Example:

Select EmpName, EmpId
From EMPTable
WHERE Empsal = '1000'