On Tuesday, 17 April 2018 23:59:25 UTC+2, Jonathan Vanasco wrote:
>
>
>
> 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 qu
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
http:/
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`.
http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#limit-off
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, system.partsupp,