Forum

What is the main di...
 
Share:
Notifications
Clear all

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

2 Posts
1 Users
0 Likes
369 Views
kumar BI
Posts: 12
 kumar BI
Guest
Topic starter
(@kumar BI)
Active Member
Joined: 2 years ago

Difference between "BETWEEN and "IN"

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

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: