Hi ,
my query is:
select distinct calendarmonthkey, calendarmonth from dim.date
order by calendarmonthkey
Result:
205801 jan 2058
205802 feb 2058
....
....
198001 jan 1980
expected result is :
201307 jul 2013
201306 jun 2013
201305 may 2013
......
.....
198001 jan 1980
or else it can be starts with previous month(jun 2013).
please suggest
Regards,
Niharika