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.

Wow they surely hate protonmail

!fakebandnames@lemmy.world

Is your husband my girlfriend?

Thanks!

Could you explain why that is The case? Interested to hear

Uhm… Are two of them in that pot?

Anya Taylor-Joy

Correct, they announced it two months ago: https://www.androidpolice.com/bitwarden-app-about-prettier/

Same, staying with bitwarden for now

Jacha-chacha-chacha-chow!

Sympathy for the devil?

Yeah the scene is great! And it’s amazing too see then all together at NAC at the moment, great vibes! For those interested, big tourney going op at the moment (starts again in 2/3 hours): https://www.twitch.tv/nili_aoe?sr=a

I watch him indeed, among others

Love this game, both playing it and watching it being streamed, there is a great tournament happening at the moment.

FTW. For years I thought it meant “Fuck The What”. Even now that’s the first thing that comes to mind and have a hard time remembering the actual meaning.

!remindme 24h

I started on the Tawny Man triology by Robin Hobb, love it so far!

I checked a few samples, for all there was at least 1 chapter as a preview. But it differs, one also had 3 with around 40 pages. I only counted actual pages, not into, table of contents etc. Hopefully that gives you an idea!

I usually buy them on my phone (Kobo app), which is easier with payments. Afterwards the book is immediately available on my e-reader. Started doing this a couple of months back and I like it. You can also preview books, but got no personal experience with that.