• SQL BETWEEN Operator – SQL TUTORIAL | Software Testing Material

    SQL BETWEEN Operator:

    SQL BETWEEN operator selects values within a range. The values can be numbers, text, or dates.

    SQL BETWEEN Syntax:

    SQL BETWEEN Example:

    In the below image, you could find three SELECT queries. First SELECT query returns complete records from the table SCOREBOARD where as other two SELECT queries returns based on WHERE Clause.

    In the second and third SELECT query, we took BETWEEN Operator.

    Second query returns the values where values in the Runs column are between 90 and 100 and the third query returns where the values in the Runs column are between 20 and 100.

    SQL Between

    SQL NOT BETWEEN Operator:

    Syntax:

     Example:

    In the below image, you could find three SELECT queries. First SELECT query returns complete records from the table SCOREBOARD where as other two SELECT queries returns based on WHERE Clause.

    In the second and third SELECT query, we took BETWEEN Operator.

    Second query returns the values where values in the Runs column are not between 90 and 100 and the third query returns where the values in the Runs column are not between 20 and 100.

    SQL Not Between

    In the next tutorial, we will see How To Use AND OR OPERATOR in SQL

    Check out the complete SQL Tutorial by clicking on below link:

    SQL Tutorial – Complete

    Sharing is caring.

    Share on facebook
    Facebook
    Share on twitter
    Twitter
    Share on linkedin
    LinkedIn

    Like This Post?

    We have a lot more where that came from?

    We only send really good stuff occasionally, promise.

    Rajkumar SM

    Leave a Comment

    Your email address will not be published. Required fields are marked *

    Share on facebook
    Share on google
    Share on twitter
    Share on linkedin
    Share on whatsapp

    Recent Posts:

    Scroll to Top
    API Testing eBook

    DOWNLOAD FOR FREE