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

Leave a Comment

API Testing eBook

DOWNLOAD FOR FREE