Re: [SQLObject] How can I implement this sql in SQLObject?

[Oleg B. <ph...@ma...>]

On Sat, Apr 15, 2006 at 02:07:57AM +0800, Henotii wrote:
> How can i implement sql like
> "select top 10 * from table order by some_columns"
> in SQLObject?

MyTable.select(orderBy=MyTable.q.some_column)[:10]

   And no, this does not mean "select all, then cut top 10". SelectResults,
the result of .select() call does intelligent things with indices.
   SQLObject supports "SELECT TOP" for MSSQL.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.