On 2014-07-22 10:19, 'checkmail' check_mail@... [firebird-support]
wrote:

> is there another solution to get every 5th record? Mod is problematic, because the starting record is not in every case the first number mod (x) = 0 and I would take all records to calculate…

Each record will yield a mod value so continue to use the mod expression
in the select statement but instaead of using =0 change it to match the
mod value for the first record you want to see. For example, if the
first record you want to see yields a mod(x)=2 then use where mod(x)=2
in your select instead of mod(x)=0. You will still see every 5th record
but the sequence will start with the desired first record.

--

Cheers!
Rich Saunders


[Non-text portions of this message have been removed]