diff options
| author | Jonathan Ellis <jbellis@gmail.com> | 2007-01-24 00:13:45 +0000 |
|---|---|---|
| committer | Jonathan Ellis <jbellis@gmail.com> | 2007-01-24 00:13:45 +0000 |
| commit | 4e9aaff50ff679fc51c4d799b000c2fcfc70a999 (patch) | |
| tree | 637d8507630b8ffa9930193bb7ec731482e898dd | |
| parent | 2a7a5525c0088fa478004aaa87bf0076b7ca336a (diff) | |
| download | sqlalchemy-4e9aaff50ff679fc51c4d799b000c2fcfc70a999.tar.gz | |
note support for LIMIT in firebird and mssql
| -rw-r--r-- | doc/build/content/sqlconstruction.txt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/build/content/sqlconstruction.txt b/doc/build/content/sqlconstruction.txt index 507f97ebf..213456220 100644 --- a/doc/build/content/sqlconstruction.txt +++ b/doc/build/content/sqlconstruction.txt @@ -426,7 +426,7 @@ These are specified as keyword arguments: {sql}c = users.select(limit=10, offset=20).execute() SELECT users.user_id, users.user_name, users.password FROM users LIMIT 10 OFFSET 20 -The Oracle driver does not support LIMIT and OFFSET directly, but instead wraps the generated query into a subquery and uses the "rownum" variable to control the rows selected (this is somewhat experimental). +The Oracle driver does not support LIMIT and OFFSET directly, but instead wraps the generated query into a subquery and uses the "rownum" variable to control the rows selected (this is somewhat experimental). Similarly, the Firebird and MSSQL drivers convert LIMIT into queries using FIRST and TOP, respectively. ### Inner and Outer Joins {@name=join} |
