What is the main di...
Clear all

What is the main difference between ‘BETWEEN’ and ‘IN’ condition operators?

kumar BI
Posts: 12
 kumar BI
Topic starter
(@kumar BI)
Joined: 2 years ago

Difference between "BETWEEN and "IN"

Topic Tags
1 Reply
Siva Kumar
Posts: 36
 Siva Kumar
(@Siva Kumar)
Joined: 2 years ago

BETWEEN operator is used to displaying rows based on a range of values in a row whereas the IN condition operator is used to check for values contained in a specific set of values.

Example of BETWEEN:
SELECT * FROM Students where ROLL_NO BETWEEN 10 AND 50;

Example of IN:
SELECT * FROM students where ROLL_NO IN (8,15,25);


Leave a reply

Author Name

Author Email

Title *

Preview 0 Revisions Saved