>>>Hi All,
>>>
>>>Need a little help to construct an efficient SELECT statement. I have a cursor containing N records. I want to select every Xth record startng with and including the last record in the source cursor. So I want records:
>>>
>>>N
>>>N - X*1
>>>N - X*2
>>>N - X*3
>>>...
>>>...
>>>
>>>What is the select statement for this keeping in mind also that X will probbaly not be a factor of N. i.e. I may have 79 records and require every 7th record starting from the last record going backwards.
>>>
>>>Thanks
>>

,

>>Jos,
>>
>>If the cursor is already in the right order
>>
>>

>>select * from CursorName ;
>>     where ( empty(mod(recno() - 79, 7)) )
>>
>>
>>or starting with last record
>>
>>select recno() as xx,  * from CursorName ;
>>     where ( empty(mod(recno() - 79, 7)) ) ;
>>     order by 1 desc
>>
>>

>
>
>Thanks Gregory. I worked out a similar solution but your's is slightly cleaner.

You're welcome