Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

kinda. You can use aggregates as window functions, but cannot use window functions as aggregates.

So it would be:

    select a, last_value(b) over(partition by a), last_value(c) over(partition by a) from table
Note the lack of a "GROUP BY" so this will result in duplicates unless you add a DISTINCT.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: