In DAL, I don´t know If this can be done.
On 9 jun, 10:40, luifran <lbernalhernan...@yahoo.es> wrote: > 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?
