For training related to .net,OOPS,design patterns, MVC,WCF and .net fundamentals
contact at sukeshmarla@gmail.com or Click Here

Click here for my training feedbacks

Followers

Follow Us



Share your Interview questions here


For software development queries contact SukeshMarla@Gmail.com

Follow by Email

Learn everything about JSON in a day

01 October 2011

Between operator in Sql



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