Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • IN operator

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 403
    Comment on it

    IN Operator use:

    It allows us to put multiple values in a where clause . With the help of this we can compare multiple values wtih where.

    Syntax:

    Select columnname(s) from Tablename where columnname IN(value1,value 2, .... value n);
    

    Example:

    SELECT name FROM Employee where city IN('Delhi','Mumbai','Bengaluru');
    

    This query will find those person names who lives either in Delhi or Mumbai or Bengaluru .

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: