Super cool, but "Jessup first posted on X, ‘The Everything App’ " is so cringe.
Super cool, but "Jessup first posted on X, ‘The Everything App’ " is so cringe.
This is what peak pro-life looks like.
Gotem coach
I am both the leaf, and the fruit flies who copulate on it.
Smithereens you say!? Tell me more.
The vegans an angry, toxic bunch lol
They’re so small and adorable aren’t they?
Of course it was the vegans.
It really is such a perfect juxtaposition of toxic vs. healthy masculinity.
This looks like my ex. I’m not even tryna be mean, it just does.
What a weird little man.
That headline is a wild ride
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?
That was actually an interesting read. First one from a game journalist in a while lol. Crazy how much energy they spent on just one, rather small character.
For when you want to watch someone go fuck themselves…
Don’t kink shame me!