What does the BETWEEN clause do?
1Times asked
May 2026Last seen
May 2026First seen
💡 Model Answer
The BETWEEN clause in SQL filters rows where a column’s value falls within a specified inclusive range. It is equivalent to a combination of two comparisons: column >= lower AND column <= upper. For example, SELECT * FROM employees WHERE salary BETWEEN 50000 AND 70000; returns employees whose salary is between 50,000 and 70,000, inclusive.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500