> in a Table I'm looking for the right 5 records for each workplace on a
> conveyor track (max-id of the records - offset for the workplace) but
> ascending sorted.
>
>
>
> For example, the max ID is 200 (last record). The Offset is 10. If I select
> first 5 skip 10 fields from table order by id desc, then I get the IDs 190,
> 189, 188, 187, 186. But I need the records ascending! If I sort ascending,
> then I get the IDs 6, 7, 8, 9, 10. How can I get the last IDs in ascending
> order?

select * from (
select first 5 skip 10 fields from table order by id desc
)
order by ... asc



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
******************************************************
70% discount on all our products until end of May 2012
******************************************************

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/