Put it at the begin of the query. It will be clear and, over all, more easy to implement (read it as 'grammar'). Examples: SKIPING 50 TAKING 25 select e.Name, e.Surname from Employee e ...... SKIPING 50 TAKING 25 from Employee from Users u where u.Employee in (TAKING 25 from Employee e order by e.Salary desc)
On Sun, Feb 6, 2011 at 2:23 PM, Patrick Earl <[email protected]> wrote: > Based on the feedback so far, it seems like the simpler syntax is more > desired. What are people's preferences around the following two > options? > > SKIP x TAKE y > OFFSET x LIMIT y > > Seems like Fabio and Diego prefer the first two. I'm also liking the > skip and take a bit more at this point, since it's more descriptive, > despite being less standard from a SQL perspective. Other's thoughts? > > Patrick Earl > -- Fabio Maulo
