• SQL IN Operator – SQL TUTORIAL | Software Testing Material

    SQL IN Operator:

    The SQL IN operator allows you to test if an expression matches any value in a list of values. It is specified with in a WHERE clause.

    Syntax:

    Example:

    In the below image, you could see two SELECT queries. First SELECT query returns the complete records from the table SCOREBOARD. Second SELECT query returns only the values based on the condition (i.e., Runs with in 90 to 100)

    SQL In Operator

    In the next tutorial, we will see How To Use BETWEEN 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 *

    Scroll to Top
    API Testing eBook

    DOWNLOAD FOR FREE