Petite Abeille <petite.abei...@gmail.com> wrote: > 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
So there aren't actually FIRST and LAST aggregate functions, it seems - at least not the way the OP envisions them. The syntax is completely different. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users