News for hackers. Stuff that matters.
Re:Advanced SQL window function quiz by einhverfr on Friday February 09, 2018 @09:39AM (#16340432)
I guess window functions are advanced features, but I found it a little bit basic. Some things you could do to make it more advanced:

    * add questions about range mode
    * have questions which discuss default behavior regarding ordering and partitioning
    * Have questions which rely on things like RANGE 3 PRECEDING or other constructs
Re:Advanced SQL window function quiz by dwanvik on Monday February 12, 2018 @09:07AM (#16358600)
Last time I checked, PG didn't support RANGE <value> PRECEDING, only RANGE UNBOUNDED PRECEDING. The new MySQL 8.0windowing functions do, though.