Timeline for How to use LAST_VALUE in PostgreSQL?
Current License: CC BY-SA 4.0
6 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Sep 25, 2019 at 13:15 | comment | added | Jeremy | We didn't specify an order for the result, if we had, we could order by whatever we want. | |
Sep 25, 2019 at 12:59 | comment | added | Gaëtan |
Thanks a lot for your answer, but I am even more confused now. The ORDER BY is applied to the result as well ? I though it was only for ordering the frame before LAST_VALUE picked its result.
|
|
Sep 25, 2019 at 12:51 | comment | added | Jeremy | Sure, that would give the same (incorrect) result. I was just trying to use the syntax that @thebuleon29 used. | |
Sep 25, 2019 at 12:46 | comment | added | S-Man |
Why not ORDER BY value NULLS FIRST instead of your CASE clause?
|
|
Sep 25, 2019 at 12:22 | history | edited | Jeremy | CC BY-SA 4.0 |
added 1899 characters in body
|
Sep 25, 2019 at 12:09 | history | answered | Jeremy | CC BY-SA 4.0 |