Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
extrememacaroni
on Jan 6, 2021
|
parent
|
context
|
favorite
| on:
Introduction to Window Functions in SQL
SQL is only secondary in my work but I'd rather go with the explicit and verbose queries rather than with stuff with surprises like how the last_value gives wrong results when used the way you'd expect i.e. the reverse of first_value.
adilkhash
on Jan 6, 2021
[–]
if you understand the window ranges, especially the default one there is no surprise at all
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: