On 1/25/17, [email protected] <[email protected]> wrote: > > I get weird sql result with subselect too > select * from (select row_number(name) as id,name from example ) t where > id<=5 >
SQLite is invoking your row_number() function twice for each row - once for the return value and a second time when evaluating the "id<5" expression. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
