1.

What Is The Sql " In " Clause?

Answer»

SQL IN OPERATOR is used to see if the value exists in a GROUP of values. For instance the below

SQL checks if the Name is either 'David' or 'Craig' SELECT * FROM wbEmployee WHERE name IN ('David','Craig') Also you can specify a not CLAUSE with the same. SELECT * FROM wbEmployee WHERE AGE NOT IN (30,25)

SQL IN operator is used to see if the value exists in a group of values. For instance the below

SQL checks if the Name is either 'David' or 'Craig' SELECT * FROM wbEmployee WHERE name IN ('David','Craig') Also you can specify a not clause with the same. SELECT * FROM wbEmployee WHERE age NOT IN (30,25)


Discussion

No Comment Found

Related InterviewSolutions