On 2014-07-22 10:19, 'checkmail' [email protected] [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]
