Umesh Kumar

Umesh Kumar

  • NA
  • 126
  • 30.9k

Sql Server Date between Query

May 29 2014 10:41 AM
Hi I have a Table as below

Month Year  Rate
1        2013  100
2        2013  101
8        2014  105

The rate is the value for the Month(1)January and year 2013.

I wana have a query which need to get rate value between 3rd month 2013 and 5the month 2014.

The Output has to be

3 2013 101
4 2013 101
5 2013 101

to 

4 2014 105
5 2014 105


Answers (3)