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.

OR logical operator can use alone

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)