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