> At least we all agree.

Are we all bored by the low traffic lately? SCNR. ;-)

Regards,
Thomas

> *g*
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
>
>
>>> 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
>>
>>
>>
>> --