Subject Re: AW: AW: [firebird-support] Generator
Author Mark Rotteveel
On Tue, 8 May 2012 15:33:50 +0200, "Olaf Kluge" <olaf.kluge@...>
> Thank you, but how can I implement the offset in this case? I need the
> last records, but every workstation has an offset. WS1 vor example needs
> the 10 last records + an offset of 10. In this case I need the last 20
> records and use the Records 11 to 19. The first 10 records I do not
> On one position there is a reading point. Now the skid with a car goes
> and one. On the tenth position there is a workstation. This needs the
> records, but with an offset of 10. Other workstations needs other
> Thanks a lot.

Could you look into the way your mailprogram is quoting lines? It is very
confusing the have my own text not quoted in your emailmessage.

Checkout the manual for ROWS:
In other words: ROWS 5 TO 10 if you want to skip the first 5 (or last 5
when you are using a DESC ORDER BY).