On Tue, 8 May 2012 15:33:50 +0200, "Olaf Kluge" <olaf.kluge@...>
wrote:

> Thank you, but how can I implement the offset in this case? I need the

10

> 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

need.

> On one position there is a reading point. Now the skid with a car goes

one

> and one. On the tenth position there is a workstation. This needs the

last

> records, but with an offset of 10. Other workstations needs other

offsets.

>
> 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:
http://www.firebirdsql.org/refdocs/langrefupd25-select.html#langrefupd25-select-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).

Mark