SQL BETWEEN clause

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:-

select * from humanresources.employee where employeeid between 1 and 10

between clause example
SUMMARY

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

 

Share your thought