overview for anonymouse

To the center of the earth!📉 in c/lemmyshitpost@lemmy.world

[–] anonymouse@sh.itjust.works 2 points 1 month 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/thenetherlands@feddit.nl

[–] anonymouse@sh.itjust.works 4 points 2 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 2 months ago by anonymouse@sh.itjust.works to c/ebookdeals@literature.cafe

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 2 months ago by anonymouse@sh.itjust.works to c/fantasy@lemmy.ml

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@sh.itjust.works

[–] anonymouse@sh.itjust.works 1 points 3 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/sql@lemmy.world

[–] anonymouse@sh.itjust.works 2 points 3 months ago* (last edited 3 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.