On Wed, Nov 23, 2011 at 1:29 PM, Wiktor Adamski <bardzotajneko...@interia.pl> wrote: >> Apparently, using such a function in ORDER BY >> clause alone doesn't make the statement aggregate (whether it should is >> perhaps debatable) > > I suppose this may be in the standart. I'm 100% sure that this one is > allowed by standart: > ... ORDER BY avg(a) OVER() > so likely ORDER BY avg(a) is also allowed.
I believe OVER() is an Oracle-specific extension to SQL, not a standard in any way. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users