>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