Subject AW: [firebird-support] Skip records

Hello again,

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…

 

Thank you

 

------

 

and mod(id,:teiler)=0)

it works

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 22.
Juli 2014 14:47
An:
firebird-support@yahoogroups.com
Betreff: [firebird-support] Skip records

 

 

Hello,

 

I would like to read every n record, depending on number of records.

 

Mod() does not work in a condition, how can I realize it with an for loop? Or should I take a while-loop?

 

Thanks

 

Best regards.

 

Olaf