efficient way to process data

[Larry Martell]

On Sun, Jan 12, 2014 at 2:53 PM, Petite Abeille
<petite.abeille at gmail.com> wrote:
>
> On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.martell at gmail.com> wrote:
>
>> AFAIK, there is no way to do this in SQL.
>
> Sounds like a job for window functions (aka analytic functions) [1][2].
>
> [1] http://www.postgresql.org/docs/9.3/static/tutorial-window.html
> [2] http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions004.htm#SQLRF06174

Unfortunately, MySQL does not support this.