overview for anonymouse

To the center of the earth!📉 in c/[email protected]

[–] anonymouse 2 points 2 months ago

Nice one, forgot this was an option too. You are missing a set of brackets though ;)

Netherlands at 43% participation for "Tax The Rich" petition in c/[email protected]

[–] anonymouse 4 points 3 months ago (1 children)

Had The same issue yesterday, was probably related to all the digital issues in NL yesterday. I tried again and its working now, just thought to let you know!

4

Humble Books Bundle: Patrick Rothfuss' The Kingkiller Chronicle by DAW Books (www.humblebundle.com)

submitted 4 months ago by anonymouse to c/[email protected]

2 comments fedilink

cross-posted from: https://sh.itjust.works/post/24201963

Good deal and great series. Just bought and redeemed it using Kobo, very smooth experience.

12

Humble Books Bundle: Patrick Rothfuss' The Kingkiller Chronicle by DAW Books (www.humblebundle.com)

submitted 4 months ago by anonymouse to c/[email protected]

6 comments fedilink

Good deal and great series. Just bought and redeemed it using Kobo, very smooth experience.

Olympic Games 2024 Closure Ceremony in c/olympics

[–] anonymouse 1 points 4 months ago (1 children)

I think he was an alien

What are your thoughts on when to use LAST_VALUE() vs. MAX() KEEP(DENSE_RANK LAST ... ) in c/[email protected]

[–] anonymouse 2 points 5 months ago* (last edited 5 months ago) (1 children)

First of all thanks for this list, I didn't know about the KEEP functionality so read up on it a bit, I found the following interesting read: https://rwijk.blogspot.com/2012/09/keep-clause.html?m=1

I can't really play around with it at the moment as it seems Oracle only (I think) and I'm not using that at the moment. Might also explain preference for last/first value of your colleague cause it seems more general available.

Question from my side, why is DENSE_RANK used in this case? Seems to me like RANK or ROW_NUMBER could perform better, since there is less to keep track off? Of course ROW_NUMBER could give different results if there are duplicates in the ORDER BY column, but in that case the MAX is also sort of an arbitrary choice.