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.

More Articles

 

Share your thought



PLEASE DISABLE ADBLOCKER AND SUPPORT US!

Please support us by enabling ads on this page. Refresh

YOU DON'T LIKE ADS, WE ALSO DON'T LIKE ADS!
 
But we have to show ads on our site to keep it free and updated. We have to pay huge server costs, domain costs, CDN Costs, Developer Costs, Electricity and Internet Bill. Your little contribution will encourage us to regularly update this site.