3 ms·
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 abou
by einhverfr 9y ago
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
- dwanvik 9y agoLast time I checked, PG didn't support RANGE <value> PRECEDING, only RANGE UNBOUNDED PRECEDING. The new MySQL 8.0windowing functions do, though.