In SQL, Is "IN' an operator or function?
In some sites , I found .. SQL "IN" is an operator whereas in a few sites it is mentioned as a function. I got bit confused?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Akkiraju IvaturiPosted Aug 6, 2012, 4:46 PM
IN is not a function, it is an operator. It is always good to refer the help articles from the sites of the companies who have defined or part of setting standards for SQL. Please have a look at the following URL from Microsoft:
http://msdn.microsoft.com/en-us/library/ms189773
Operator
Meaning
ALL
TRUE if all of a set of comparisons are TRUE.
AND
TRUE if both Boolean expressions are TRUE.
ANY
TRUE if any one of a set of comparisons are TRUE.
BETWEEN
TRUE if the operand is within a range.
EXISTS
TRUE if a subquery contains any rows.
IN
TRUE if the operand is equal to one of a list of expressions.
LIKE
TRUE if the operand matches a pattern.
NOT
Reverses the value of any other Boolean operator.
OR
TRUE if either Boolean expression is TRUE.
SOME
TRUE if some of a set of comparisons are TRUE.
Akkiraju IvaturiPosted Aug 6, 2012, 6:06 PM
Hemant SrivastavaPosted Aug 6, 2012, 5:33 PM