In sql, you can apply first order by and then limitby for example in Oracle:
select * from (select * from table order by field) where rownum<11//row 1 to 10 after order On 9 jun, 09:52, pbreit <pbreitenb...@gmail.com> wrote: > I have a query that includes both orderby and limitby. What seems to happen > is that the db returns some set of records as dictated by the limit and then > orders the records in that set. So I pretty much get the same set every time > even though I know the field being ordered has changed for various records. > Is this how SQL works? Is there any way to order the whole set first and > then return the sub-set?
