| Subject | What is the SQL standard for FIRST/SKIP syntax? |
|---|---|
| Author | David Garamond |
| Post date | 2003-12-03T09:33:51Z |
I am not familiar with SQL standards. Looking at
http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html it
says that FIRST is a keyword, and so is LIMIT, but SKIP is not. What is
the standard SQL syntax for SKIP, or does the standard not cover
skipping (since MS SQL doesn't seem to support SKIP-like feature)?
I have to say, though, that FIRST/SKIP is the best/clearest syntax
(especially compared to MySQL's more obscure LIMIT x,y).
--
dave
http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html it
says that FIRST is a keyword, and so is LIMIT, but SKIP is not. What is
the standard SQL syntax for SKIP, or does the standard not cover
skipping (since MS SQL doesn't seem to support SKIP-like feature)?
I have to say, though, that FIRST/SKIP is the best/clearest syntax
(especially compared to MySQL's more obscure LIMIT x,y).
--
dave