Question : How does one solve the islands part of gaps-and-islands with dense_rank() and row_number(). I’ve seen this now a […]
Tag: rank
Atomic updates to ordering in a table for a waiting list application
Question : I am trying to implement a gamified waiting list. This waiting list is for eventual access to an […]
Rank vs. Distinct
Question : Just for curiosity, if I have to use rank to tag distinct values for some columns only, and […]
Atomic updates to ordering in a table for a waiting list application
Question : I am trying to implement a gamified waiting list. This waiting list is for eventual access to an […]
A more intelligent ntile
Question : When using the ntile() window function, the major issue is that it arbitrarily groups into roughly equal parts […]
How to get latest 2 records of each group
Question : So, I have table similar to: sn color value 1 red 4 2 red 8 3 green 5 […]
Get the rank of a user in a score table
Question : I have a very simple MySQL table where I save highscores. It looks like that: Id Name Score […]
A more intelligent ntile
Question : When using the ntile() window function, the major issue is that it arbitrarily groups into roughly equal parts […]
Adding an ID column based on two other columns
Question : I have a query which returns output as follows: [Location] [Reference] [Year] [Int1] [Int2] England 1 2015 13 […]
Overlaps and Gap grouping in SQL Server
Question : I am trying to find gaps in my data and then group those. The table I am working […]