>>>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
Gregory