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

Last Post

RSS

Posts: 12

kumar BI

Guest

Topic starter

Aug 04, 2020 10:52 am

(@kumar BI)

Active Member

Joined: 4 years ago

Difference between "BETWEEN and "IN"

Topic Tags

SQLBetweenandIN

1 Reply

Posts: 36

Siva Kumar

Guest

Aug 05, 2020 5:12 am

(@Siva Kumar)

Eminent Member

Joined: 4 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);