On 16-5-2012 14:39, Olaf Kluge wrote: > 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?
Use a subquery or CTE to retrieve the rows you want, and then sort them again with the outer query. Mark -- Mark Rotteveel