Don’t kink shame me!

Super cool, but "Jessup first posted on X, ‘The Everything App’ " is so cringe.

This is what peak pro-life looks like.

I am both the leaf, and the fruit flies who copulate on it.

Smithereens you say!? Tell me more.

I love blowing my Fagott.

The vegans an angry, toxic bunch lol

They’re so small and adorable aren’t they?

Aww shit. Thanks lol.

Of course it was the vegans.

I hate Walz Vance and love that he got boo’d. That said, I don’t understand why everyone is making such a big deal of him calling them “haters”. That’s literally what that word means. I’m a Walz Vance hater. Many of you are haters. It’s a description not a slur.

Edit: Yeah I fucked this one up royally, didn’t I lol? Sorry folks.

Like, I know it really happened. I believe that. But damn if there isn’t a voice in a small corner of my mind that won’t stop whispering “he faked the whole thing”.

This looks like my ex. I’m not even tryna be mean, it just does.

Hard disagree. But that’s okay, we’re allowed to like different kinds of games. Yours isn’t any more objective than mine though. If you don’t like that kind of thing, just don’t play those kinds of games. It’s not a threat to you if others enjoy them.

Yeah this is a reach. He’s a big enough turd we really don’t need to stretch this much.

What a weird little man.

Yeah, I guess it’s a less-used analytic function (function? I think that’s the right term here).

I believe this will only accept DENSE_RANK as the ranking part of this method, which makes sense cause you want a distinct list of ranks to identify the last one. You are right though that it’s possible for the record returned by the MAX() to be arbitrary if there are duplicate values in the ORDER BY field. Luckily you can usually handle for that by using multiple fields in the ORDER BY. The conditions in the query that the function operates on top of also play a roll. You can also include a PARTITION BY, but I’ve only needed to use that a time or two.

I think one reason I like this more is it’s more readable to me. For a lot of the other analytic functions you end up using partitions and additional keywords like “ROWS BETWEEN UNBOUNDED AND …etc.” in order to break out results the way you need. With this dense_rank method I typically accomplish that using regular 'ole WHERE conditions. Of course that’s gonna be pretty subjective.

Replying on in my phone now so limited in how detailed I can be. I can give better examples later if that doesn’t make sense.

Edit: I think it is an Oracle thing. Analytics are one of the areas I will unapologetically use DB-specific functions. Portability be damned! Generally they’ve been tuned very specifically to solve a problem with the specific engine in mind. Of course that won’t always be true, but that’s my general thought process.

Aww dude. What a memory.

And my vote in Oklahoma…oh fuck it who are we kidding lol. Meaningless. I still do it though.

You sure are on a tear, aren’t ya little guy?