Chapter 86 of 1963 min read
Lesson 9.2 — Ranking Functions: ROW_NUMBER, RANK, DENSE_RANK
🧬 Biological Scenario: "What's the highest expressed sample for each gene?" or "Rank samples by variant count within each tissue type" — ranking functions assign a position/rank to each row within its group. 💻 SQL…
Sign in to read this
“Lesson 9.2 — Ranking Functions: ROW_NUMBER, RANK, DENSE_RANK” is for subscribers. Start with a free account — it takes a name and an email — then subscribe for $1 a month to open it.
- Python and R courses free in full
- First two chapters of every other course