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

SQL In Operator

Get our latest blog posts delivered to your inbox

Subscribe and get popular blog posts about software testing industry.

Rajkumar

Leave a Comment

Share via
Copy link
Powered by Social Snap