On Feb 2, 2012, at 5:26 PM, Igor Tandetnik wrote: > ORDER BY applies to groups, not to rows within each group (is this different > with Oracle?)
analytic functions works in term of the result set itself. Here is a simple example: http://www.oracle-base.com/articles/misc/LagLeadAnalyticFunctions.php http://www.oracle-base.com/articles/misc/AnalyticFunctions.php _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users