Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SQL Tutorial -> Sql Where

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 118
    Comment on it

    <-- Chapter 4: SQL Distinct

    Chapter 5

    SQL Where


    SQL Where : SQL Where clause extract or filters those records which matches the specified condition. Syntax for Where clause is used below


    SELECT * 
    FROM tablename
    WHERE condition
    

    Here "condition" means that on what basis records are to be filtered, In Sql Where clause there are many operators used to filter Records such as IN,NOT IN,=,!=,LIKE, BETWEEN,<>,>,<,>=,<=

    .
    Operator Name Description
    IN It is used to check Multiple values for specified column
    NOT IN It is used not to check Multiple values for specified column
    = Equal to
    != Not Equal to
    LIKE It is used to search specified pattern
    BETWEEN It is used to check values between specified range
    <> It is same as Not Equal to
    > Greater Than
    < Less than
    >= Greater Than or Equal to
    <= Less Than or Equal to

    We will see each Operator how it works in the next chapters.

    Chapter 6: SQL IN Operator -->

 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: