over 4 years ago
It is used to fetch values which lies within a range given in BETWEEN operator.
WHERE columnname BETWEEN value1 AND value2;
SELECT * FROM Employee
WHERE Salary BETWEEN 10000 AND 20000;
The above query will fetch those employee details whose salary are between 10000 and 20000.
NOT BETWEEN Operator:
It is used to fetch values which do not lies within a range given in NOT BETWEEN operator, all other tuple which are not in the range of NOT BETWEEN operator will get fetched .
WHERE columnname NOT BETWEEN value1 AND value2;
SELECT * FROM Student
WHERE Grade NOT BETWEEN 'B' AND 'D';
The above query will fetch those student records whose grade are not between B and D.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using