I have a table AAA which has 3 columns as Month_No,Year_No and Profit.
I want to select next 15 months profit data along with month and year from table AAA.
Can anyone help me to form the teradata Query for this?
Month_No Year_No Profit
2 2011 10
3 2014 20
5 2015 20
11 2014 30
12 2013 40
7 2015 40
9 2014 50
If current date is 16/Sep/2014 then i need to select data from sep/2014 to Nov/2015 in AAA table
If Current date is 1/Dec/2013 then I need to select data from dec/2013 to feb/2015 in AAA table.
You might simply utilize Teradata's sys_calendar (or yor own calendar implementation):
WHERE (Year_No, Month_No)
IN (SELECT year_of_calendar, month_of_year
WHERE calendar_date BETWEEN CURRENT_DATE