overview for anonymouse

Olympic Games 2024 Closure Ceremony in c/olympics

[–] anonymouse 1 points 1 week 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 1 month ago* (last edited 1 month 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.

Learn to use email with git! (Interactive!) in c/[email protected]

[–] anonymouse 1 points 1 month ago (1 children)

Wow they surely hate protonmail

They don't want you to know in c/whitepeopletwitter

[–] anonymouse 6 points 1 month ago

[email protected]

What is the right way to have your toilet paper? in c/[email protected]

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

Is your husband my girlfriend?

[–] anonymouse 1 points 2 months ago

Thanks!

[–] anonymouse 2 points 2 months ago (2 children)

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

34

Xbox may have accidentally confirmed CoD: Black Ops 6 is coming to Game Pass (dotesports.com)

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

8 comments fedilink

Just got a push message from the Xbox app, but link is no longer working

First boat trip of the season. This time we took Sisu, Mimi & Roo (pictured) in c/[email protected]

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

Uhm... Are two of them in that pot?

[Solved][Progressive Rock] in c/[email protected]

[–] anonymouse 1 points 3 months ago

Fly away - Lenny Kravitz

Most unique looking celebrities? in c/[email protected]

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

Anya Taylor-Joy

Would be nice to get everyone into the same Bitcoin community in c/[email protected]

[–] anonymouse 7 points 4 months ago (2 children)

I haven't been able to find an active community on bitcoin or crypto in general, unfortunately. Got the feeling there is no big overlap in Lemmy users and Crypto enthusiasts. Feeling also supported by the other comment on this post 😅

Biden watching college students (a core democratic constituency) protesting against genocide in c/[email protected]

[–] anonymouse 1 points 4 months ago

Sorry to say, but you're right