SQL BETWEEN clause

OBJECTIVE

In this chapter you will learn:

About between clause
Syntax of between clause
Example of between clause

 

About between clause

SQL between clause is used to retrieve data within some conditions or limit or range. It can be used to retrieve numbers, text or date.

 

Syntax of between clause

SELECT column_name from table_name where column_name between value1 and value2

 

Example of between clause:-

 

 

between clause example

 

SUMMARY

In this chapter you have learned about between clause so click on the next button to know about aggregate function.


Leave a Reply

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