overview for anonymouse

Olympic Games 2024 Closure Ceremony in c/[email protected]

[–] [email protected] 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]

[–] [email protected] 2 points 4 weeks ago* (last edited 4 weeks 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]

[–] [email protected] 1 points 1 month ago (1 children)

Wow they surely hate protonmail

They don't want you to know in c/[email protected]

[–] [email protected] 6 points 1 month ago

[email protected]

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

[–] [email protected] 4 points 1 month ago (1 children)

Is your husband my girlfriend?

[–] [email protected] 1 points 2 months ago

Thanks!

[–] [email protected] 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 [email protected] to c/[email protected]

7 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]

[–] [email protected] 16 points 2 months ago (1 children)

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

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

[–] [email protected] 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]

[–] [email protected] 7 points 3 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]

[–] [email protected] 1 points 3 months ago

Sorry to say, but you're right

Introducing Dark Web Monitoring for credential leaks in c/[email protected]

[–] [email protected] 9 points 4 months ago (1 children)

Coming in the future for custom domains as well, amazing!