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