I agree. HQL is already supposed to be an abstraction over the (underlying) DB query language. SKIP and TAKE are probably more evocative of what you're declaring as your intent with the statement.
Steve Bohlen [email protected] http://blog.unhandled-exceptions.com http://twitter.com/sbohlen On Sun, Feb 6, 2011 at 12:45 PM, Hoang Tang <[email protected]> wrote: > I vote for the skip and take version... they all need to be translated > anyway why not pick something that is easy to remember > On Feb 6, 2011 11:23 AM, "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 >
