Hi all,

I have mytable :

mytable.dbf

YearMonth ( character field )

200609
200609
200608
200608
200607
200607
200606
200606
200605
200605
200604
200604
200603
200603
200602
200602
200601
200601
200512
200512
200511
200511
200510
200510
200509
200509
200508
200508
200507
200507
200506
200506

to get only last 12 months :

newtable ( 2 fields )

yearmonth MaxMiniMonth
200609 12
200608 11
200607 10
200606 9
200605 8
200604 7
200603 6
200602 5
200601 4
200512 3
200511 2
200510 1

Select yearmonth from mytable group by yearmonth

How to get MaxMiniMonth in my select SQL ?

TIA