性能价格比最好的手机服务 3 months of 5GB 4G LTE a month and unlimited talk and text for only $20 bucks.

Author Topic: Difference between Where ID in (200, 500) and Where ID between 200 AND 500  (Read 253 times)

Melanie.Lee

  • Core Package
  • Jr. Member
  • *
  • Posts: 54
  • Karma: +0/-0
Hi all tutors and classmates,
To me, the two Where conditions are same in SQL queries. But I know there must be some differences. 
Appreciate your help in advance.


The original question is copied as below:
If you want to select all rows from the STUDENT table where student ID is any number between 100 and 500,  which of the below Where conditions would you use?
a. Where ID in (100,500}
b. Where ID Between 100 AND 500