Logical operators are used to detecting the truth associated with the condition, some of the operators are-

  • ALL- if the entire set of operation is true then it returns the value true
  • AND- if the Boolean expressions are true then it returns the value true
  • IN- if the operand is equal to the list of expressions then it returns the value true
  • ANY- if the set of comparisons are true then it returns the value true
  • NOT- it is used to reverse the values of Boolean operators

These commands have a major place in MSSQL interview questions and answers

BY Best Interview Question ON 17 Oct 2019