The Between operator in SQL can be used to select values within a given range.
Syntax
SELECT column_names
FROM table_name
WHERE column_name BETWEEN first_Value AND second_Value;
Use of NOT Between operator in SQL Query
SELECT * FROM students
WHERE fee NOT BETWEEN 1000 AND 2000;
Use of Between operator in SQL Query
SELECT * FROM students
WHERE fee BETWEEN 1000 AND 2000;
Excercise: Download the Database of Between operator in SQL and practice it on your XAMPP phpMyAdmin.
CEO @ T4Tutorials.com
I welcome to all of you if you want to discuss about any topic. Researchers, teachers and students are allowed to use the content for non commercial offline purpose. Further, You must use the reference of the website, if you want to use the partial content for research purpose.
I welcome to all of you if you want to discuss about any topic. Researchers, teachers and students are allowed to use the content for non commercial offline purpose. Further, You must use the reference of the website, if you want to use the partial content for research purpose.
Latest posts by Prof. Fazal Rehman Shamil (see all)
- How Students Can Pick a Good Custom-Paper Writing Service? - March 5, 2021
- List of Public service commissions - August 31, 2020
- Comparison of fee structure of Pakistani Universities - June 1, 2020