SQL Server Transact Basic to Expert - Select Query With Unambiguous Where condition

This blog we are going to see an unambiguous condition in the where clause by using different operators like AND, NOT, LIKE. We can use this to put on multiple conditions request

The order of using the operator to prepare the result will be the order in which we are specifying.

Example:

Select *
From EmpTable
Where empName = 'Karthik' AND empId = '3' OR empSal = '2000'