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

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 215
    Comment on it

    This operator is used to get the data from a combination of " greater than equal " and " less than equal " condition .
    Syntax :

    select column_name1.......column_nameN from table_name where column_name between value1 and value2 ;
    

    Example :
    Table name : Employee_Info

      Id        Employee_name          Employee_Age         Employee _Salary     City 
      1            Mukesh                  23                  100000            Meerut
      2            Ayush                   24                  200000            Baroda
      3            Ishan                   40                  400000            Multan
      4            Pranav                  35                  123,00000         Dehradun
      5            Abhishek                26                  800000            Mussoorie
      6            Ravi                    25                  300000           Pauri-Garhwal
      7            David                   40                  8000              Baghpat
    

    Query :

    select * from Employee_Info where Employee_Salary between 200000 and 100000 ;
    

    Output :

    Id        Employee_name          Employee_Age         Employee _Salary      City
     3            Ishan                   40                  400000            Multan
     5            Abhishek                26                  800000            Mussoorie
     6            Ravi                    25                  300000           Pauri-Garhwal
    

 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: