OR logical operator can use alone

Question

Sir, i am working on SQL server. I got a problem i want to know that we should always use other logical operator with NOT operator. Is this mandatory to us other operator (AND ,OR) with NOT operator

Vilas Gite · Answer

hI Gurjeet R u clear doubts? if yes? ------------------------------------------------------- If this reply solve your post…then " MARK AS ANSWER "!

Vilas Gite · Answer

Hi gurjit Lets see good SQL reference ebook. Regarding your post, please see page no 3-196. I think it could be clear your doubts. --------------------------------------------------------------------------- If this reply solve your post…then " MARK AS ANSWER "!

Sandeep Shekhawat · Answer

Not operator can not be use independently. In Sql Server it use With IN and Exists means NOT IN and NOT Exists.

Sam Hobbs · Answer

I am not as experienced with SQL as the others here but since the NOT operator is a logical operator it requires a boolean value. So it is usually used with other logical operators since then the type of the expression is boolean. I don't know what would happen if the NOT operator was used with non-boolean data but my guess is that SQL would complain.

raghu v · Answer

it not mandatary to use other operators but it depends on ur requirements but if u need to use 'and' or 'or' operator check the result of the all apparators order which may affect ur results

Vulpes · Answer

The answer to your question is that NOT can be used independently - it doesn't have to be used with AND or OR though it usually is.

Suthish Nair · Answer

It depends upon the requirement and what output you need to generate. Build different quires and check the execution and statistics.