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

  • SQL Tutorial -> SQL BETWEEN Operator

    @deepak.uniyal
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 324
    Comment on it

    <-- Chapter 10: SQL LIKE Operator

    Chapter 11

    SQL BETWEEN Operator


    Lets see an example from the below table "employees" :-


    employee_id name code designation salary
    101 ABC E-101 Engineer 12000
    102 DEF E-102 Doctor 8000
    103 GHI E-103 Software Developer 8000
    104 JKL E-104 CEO 12000
    105 MNO E-105 Software Developer 100000

    BETWEEN Operator Example


    1. SELECT * 
    2. FROM `employees`
    3. WHERE `salary` BETWEEN 9000 AND 15000;

    Now Run this Query, we will see the output below :-


    employee_id name code designation salary
    101 ABC E-101 Engineer 12000
    104 JKL E-104 CEO 12000

    We can see here, that only those records are displayed which column salary value varies between 9000 and 15000


    Chapter 12: SQL > Operator -->

    SQL SQL Between Operator
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: