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