| Subject | Re: AW: [firebird-support] Skip records |
|---|---|
| Author | Saunders, Rich |
| Post date | 2014-07-22T14:29:52Z |
On 2014-07-22 10:19, 'checkmail' check_mail@... [firebird-support]
wrote:
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]
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]