On Nov 23, 2011, at 7:58 PM, Pavel Ivanov wrote: > I believe OVER() is an Oracle-specific extension to SQL, not a > standard in any way.
Well, over( partition by... order by ... ) is part of the analytical syntax of Oracle... nothing to do with ordering a result set... Function(arg1,..., argn) OVER ( [PARTITION BY <...>] [ORDER BY <....>] [<window_clause>] ) http://orafaq.com/node/55 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users