Scenario: Consider you have a Table Say Student with Column say Age.
Student--
Age
-----
1
2
3
3
4
5
6
5
Question: What will be the result of the following query? With reason
(Use of query analyzer is not permitted,just think and answer)
Declare @Number1 int=4
Declare @Number2 int=2
SELECT * FROM Student
WHERE Age BETWEEN @Number1 and @Number2