On Tuesday, April 17, 2018 at 5:58:32 PM UTC-4, Jonathan Vanasco wrote:
>
>
> So .limit() is .top()
>
Clarified: `limit()` is essentially the same as if there were a `top()`,
because it will emit `TOP` for the query.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
SqlAlchemy doesn't natively support `TOP` because it's not part of standard
sql. IIRC, only mssql uses it -- and uses it instead of 'limit'.
The SqlAlchemy dialect for mssql will adapt .limit() to emit `TOP` instead
of `LIMIT`.
On Tuesday, 17 April 2018 23:17:27 UTC+2, su-sa wrote:
>
> Hi everyone!
>
> I am trying to build the following query with SQLAlchemy:
>
> "select top 100 s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address,
> s_phone, s_comment from system.part, "
> "system.supplier,
Hi everyone!
I am trying to build the following query with SQLAlchemy:
"select top 100 s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address,
s_phone, s_comment from system.part, "
"system.supplier, system.partsupp, system.nation, system.region where
p_partkey = ps_partkey "
"and