Which function returns a continuous percentile value as a window calculation in engines that support it?

Problem Statement

Explanation

PERCENTILE_CONT computes a value at the requested percentile using interpolation across ordered data. It can run as an ordered-set aggregate or as a window function. PERCENT_RANK and CUME_DIST return relative ranks between zero and one. NTILE splits rows into buckets.

Code Solution

SolutionRead Only

PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY amount)
OVER (PARTITION BY region) AS p90_amount

Practice Sets

This question appears in the following practice sets:

Window Functions & Analytics

Next Question

Master Interviews
Anywhere, Anytime

Which function returns a continuous percentile value as a window calculation in engines that support it?

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which SQL statement retrieves all columns and rows from a table named employees?

Which clause filters rows before aggregation and affects which rows are grouped?

What is the default sort order when ORDER BY is used without ASC or DESC?

Which construct is commonly used to paginate results in SQL engines like Postgres and MySQL?

Which predicate correctly checks for missing values in standard SQL?

More from SQL & Databases

Master Interviews Anywhere, Anytime

Which function returns a continuous percentile value as a window calculation in engines that support it?

Problem Statement

Explanation

Code Solution

Practice Sets

Related Questions

Which SQL statement retrieves all columns and rows from a table named employees?

Which clause filters rows before aggregation and affects which rows are grouped?

What is the default sort order when ORDER BY is used without ASC or DESC?

Which construct is commonly used to paginate results in SQL engines like Postgres and MySQL?

Which predicate correctly checks for missing values in standard SQL?

More from SQL & Databases

Master Interviews
Anywhere, Anytime