Thread: pointers to sql standard, or "most common" sql?

So, I was trying to figure out which was close to standard sql:

     select * from foo limit 10
or
     set rowcount 10 select * from foo

and couldn't find much relevant information via google.

Is the sql standard on the web, and is there some document
about the syntax variations between sybase, oracle,
mysql, and postgresql?

Many TIA!

Mark

On Mon, 2005-05-23 at 12:18, Mark Harrison wrote:
> So, I was trying to figure out which was close to standard sql:
>
>      select * from foo limit 10
> or
>      set rowcount 10 select * from foo
>
> and couldn't find much relevant information via google.
>
> Is the sql standard on the web, and is there some document
> about the syntax variations between sybase, oracle,
> mysql, and postgresql?

Do a search for sql1992.txt and you can find the review drafts laying
about the net like so many old socks in a bachelor's apartment.

As for the limit syntax, it simply isn't part of the SQL 1992 spec.
You're expected to use cursors I guess.

So, of course, EVERY database implements it just a little bit
different.  I think it was more a case of all the different interests in
the SQL 92 committee not being able to agree than disagreeing with the
idea of limit.

You can buy the SQL Standard from ANSI in PDF format for $18 per book
(there are several books).
http://webstore.ansi.org/ansidocstore/find.asp?

Under "Search" type in SQL and hit the go button.

You can get draft versions for free.  For instance:
http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Mark Harrison
> Sent: Monday, May 23, 2005 10:18 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] pointers to sql standard, or "most common" sql?
>
> So, I was trying to figure out which was close to standard sql:
>
>      select * from foo limit 10
> or
>      set rowcount 10 select * from foo
>
> and couldn't find much relevant information via google.
>
> Is the sql standard on the web, and is there some document
> about the syntax variations between sybase, oracle,
> mysql, and postgresql?
>
> Many TIA!
>
> Mark
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org