From the course: Advanced SQL – Window Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Distribution window functions - SQL Tutorial
From the course: Advanced SQL – Window Functions
Distribution window functions
- [Instructor] A cumulative distribution function, describes the probability that our random variable X evaluated at n, we'll take a value that is less than or equal to n. As a highly simplified example, consider a standard six side playing dice. Each side has a unique integer value between one and six and has a roll probability of 1/6. The cumulative distribution for rolling a value that is equal to or smaller than one is 1/6. The probability for rolling a value that is equal to or smaller than two is the sum of the previous and the current probabilities 2/6 or 1/3, similarly for a three, the permeability is 1/2 and so on up to one. One represents the probability of rolling a value that is equal to or smaller than six and that is a certainty. The NCC equal standard defines distribution window functions as functions that compute a relative rank over a row R, within a window partition of R, expressed as an approximate…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.