On Friday 31 March 2006 02:10 pm, Jonathan Vanasco wrote:
> On Mar 31, 2006, at 2:00 PM, Frank Wiles wrote:
> > Yup, you're right I just double checked and there isn't a LIMIT/
> > OFFSET
> > in the SQL standard. For someone reason... probably because it's so
> > freaking useful, I assumed it was. :)
>
> I was pretty floored when i found out myself. I *think* more dbs
> tend to do LIMIT x OFFSET x from what i've seen, but its just not in
> the spec. Crazy.
Just to be different, MS-SQL uses TOP...
which goes at the begining of the query, not the end:
SELECT TOP 10 ...
rather than
SELECT ... LIMIT 10.
:-/
--
"The Universe doesn't give you any points for doing things that are easy."
- Sheridan to Garibaldi in Babylon 5:"The Geometry of Shadows"
