Data Dungeon
← All sections

Section 3

Index Spire

Climb the tower of indexes — rank, window, and structure.

Floors 11–15 · 14 chambers · 2860 XP

Floor 11

Ascending Steps

…
  1. Chamber 33Locked

    Offset Steps

    Paginate with OFFSET

    OFFSETLIMITORDER BY
    +160 XPPreview →
  2. Chamber 34Locked

    Indexed Shelves

    Membership with IN

    IN
    +165 XPPreview →
  3. Chamber 35Locked

    Page Index

    IN plus OFFSET

    INOFFSETLIMITORDER BY
    +175 XPPreview →

Floor 12

Catalog Wing

…
  1. Chamber 36Locked

    Coalesce Plaque

    Fill NULL labels

    COALESCE
    +180 XPPreview →
  2. Chamber 37Locked

    Cast Height

    Text to number

    CAST
    +185 XPPreview →
  3. Chamber 38Locked

    Coalesce Cast

    Both null-fill and cast

    COALESCECAST
    +195 XPPreview →

Floor 13

Window Gallery

…
  1. Chamber 39Locked

    Row Number Spire

    ROW_NUMBER window

    Window
    +200 XPPreview →
  2. Chamber 40Locked

    Partition Peak

    SUM OVER PARTITION BY

    Window
    +205 XPPreview →
  3. Chamber 41Locked

    Ranked Filter

    Window plus subquery filter

    WindowSubqueryORDER BY
    +215 XPPreview →

Floor 14

Structure Vault

…
  1. Chamber 42Locked

    Round Tower

    ROUND on grouped averages

    ROUNDAVGGROUP BY
    +220 XPPreview →
  2. Chamber 43Locked

    Cross Index

    JOIN with IN

    INNER JOININ
    +225 XPPreview →
  3. Chamber 44Locked

    Window Join

    Rank after joining

    WindowINNER JOIN
    +235 XPPreview →

Floor 15

Apex Seal

…
  1. Chamber 45Locked

    Apex Prelude

    COALESCE, IN, OFFSET

    COALESCEINOFFSETLIMITORDER BY
    +240 XPPreview →
  2. Section Boss
    Chamber 46Locked

    Index Archon

    Close the Index Spire

    BossWindowINNER JOINSubqueryORDER BY
    +260 XPPreview →