On Wed, Nov 23, 2011 at 11:50 AM, Petite Abeille <petite.abei...@gmail.com> wrote: > On Nov 23, 2011, at 5:35 PM, Pavel Ivanov wrote: > >> But although it's completely senseless >> just syntactically it looks correct - should produce just one row and >> thus ORDER BY will be a no-op. > > Well, if this is about Alice in Wonderland, then, what about: > >> select max( 1 ) from t order by avg( a ); > 1
Well, apparently you did this on non-empty table. This query gives different and kind of unexpected result on empty table. ;) Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
