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
SUMMARY
In this chapter, you have learned about between clause so click on the next button to know about aggregate function.