SQL Server Transact Basic to Expert - Select Query With Comparision operators(<)

SQL Server Transact Basic to Expert - Select Query With Comparision operators

This blog shows on how to use a comparision operator to do a check with the where clause column. < operator is used as on the of the comparision operator.

Syntax:

Select column_list
From table
Where Column1 < 'Condition'

Example:

Select EmpFullname
From Emptable
Where Empsal < 4000