Ok then this will
Select yearmonth, 000 AS MaxMiniMonth from mytable group by yearmonth ORDER BY 2 DESC INTO CURSOR Result REARWRITE
lnRecs = RECCOUNT("Result"
SCAN
REPLACE MaxMiniMonth WITH lnRecs
knRecs = lnRecs - 1
ENDSCAN
>Sorry Jim. This won't works. It would give you the following result:
>
>YearMonth MinMax
>---------------------
>200609 2
>200608 2
>....
>
>
>
>
>>
>>Select yearmonth, COUNT(*) AS MaxMiniMonth from mytable group by yearmonth ORDER BY 2 DESC
>>
>>
>>
>>>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