From 4e9aaff50ff679fc51c4d799b000c2fcfc70a999 Mon Sep 17 00:00:00 2001 From: Jonathan Ellis Date: Wed, 24 Jan 2007 00:13:45 +0000 Subject: [PATCH] note support for LIMIT in firebird and mssql --- doc/build/content/sqlconstruction.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/build/content/sqlconstruction.txt b/doc/build/content/sqlconstruction.txt index 507f97ebf1..213456220b 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} -- 2.47.2