Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My 2 Cents The Logical Operators

Discussion in 'Database Management' started by Swati Mishra, Mar 17, 2016.

  1. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    Multiple search condition can be combined by using logical operators. These are three logical operators are using in the database.
    AND: when all condition true
    OR: when any condition true
    NOT: Neutralizes the expression
    Syntax

    SELECT column_List
    FROM table_name
    WHERE conditional_exporession{ AND/OR/NOT} conditional_expression
     
  2. Manish Mishra

    Yellow Belt

    Joined:
    Dec 22, 2015
    Messages:
    1,025
    Ratings:
    +159 / -0
    the logical operator uses three expressions And, Or and Not that defines as; And to join to or more column together, Or to one of two or more table and Not defines the neither of any, respectively.
     
  3. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    These all three (AND/OR/ NOT) have their own reason to use in different places. If any condition will satisfy then it shows the result according to match with this operator
     

Share This Page