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

This blog shows on how to use a Where clause with select clause for negative select condition scenarios using NOT operator

Syntax:

Select column_list
from table
where not column1=""

Example:

Select empname
from emptable
where not empsal = '3000'