Chapter 22

The Quantile Function

“There is flattery in friendship.”

– William Shakespeare

Table of Contents Chapter 22 – The Quantile Function

The Quantile Function and Syntax

A Quantile Example

A Quantile Example using DESC Mode

QUALIFY to find Products in the top Partitions

QUALIFY to find Products in the top Partitions Sorted DESC

QUALIFY to find Products in the top Partitions Sorted ASC

QUALIFY to find Products in top Partitions with Tiebreaker

Using Tertiles (Partitions of Four)

How Quantile Works

The Quantile Function and Syntax

The syntax for the Quantile function

QUANTILE (<partitions>, <column-name> ,<sort-key> [DESC | ASC]) [QUALIFY QUANTILE (<column-name>) {< | > | = | <= | >=} <number-of-rows>]

A Quantile is used ...

Get Tera-Tom's 1000 page e-Book on Teradata now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.