Forum

What is the main di...
 
Notifications
Clear all

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


kumar BI
Posts: 12
 kumar BI
Topic starter
(@kumar BI)
Joined: 1 year ago

Difference between "BETWEEN and "IN"

Topic Tags
1 Reply
Siva Kumar
Posts: 36
 Siva Kumar
(@Siva Kumar)
Joined: 1 year 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);

Reply
Share: