</>SkillRecallRECALL WHAT YOU KNOW
Prepare for an interviewExplore Library
Databases & SQLWindow Functions

32 items

1

Running Total With Tied Dates

Code Quiz
2

Leak-Free Running Average Feature

Quiz
3

Window Functions for Feature Engineering

Flashcard
4

Window Functions for Feature Engineering

Slides / Video
5

Rolling Feature Data Leakage Bug

Code Quiz
6

Leak-Free Rolling Features

Quiz
7

Window Functions for Feature Engineering

Flashcard
8

Window Functions Inside CTEs

Quiz
9

Windows for Feature Engineering

Slides / Video
10

Top Earner Per Department Bug

Code Quiz
11

Filtering on a Window Function Result

Code Quiz
12

Filtering on Window Function Results

Quiz
13

Window Functions With CTEs

Slides / Video
14

Filtering on Window Function Results

Flashcard
15

Percent-of-total With a Window Frame Bug

Code Quiz
16

Nesting Aggregates Inside Window Functions

Quiz
17

Cohort Retention Trend Bug

Code Quiz
18

Filtering On Window Function Results

Quiz
19

Running Total With Duplicate Dates

Code Quiz
20

Running Totals and Default Frames

Quiz
21

Cohort & Trend Analysis With Windows

Slides / Video
22

RANGE vs ROWS Default Frame Peers

Quiz
23

Default Frame: RANGE vs ROWS Gotcha

Flashcard
24

Window Functions & Advanced Aggregation

Slides / Video
25

Assigning Cohorts With Window Functions

Quiz
26

Window Functions for Cohort & Trend Analysis

Flashcard
27

Joins, Window Functions & CTEs

Slides / Video
28

Filtering on Window Function Results

Quiz
29

Combining CTEs, Joins & Window Functions

Flashcard
30

Window Functions & Query Performance

Slides / Video
31

Window Functions and Query Performance

Quiz
32

Window Functions & Query Performance

Flashcard
Flashcard

Default Frame: RANGE vs ROWS Gotcha

Explains why an ORDER BY window aggregate can silently include peer rows via the default RANGE frame.

Question

With an ORDER BY but no explicit frame, what running-total pitfall arises from the default window frame?

Click to reveal answer