Skip navigation

SQL Window Functions

score 15
You have not voted. Active

What

Support SQL Window Functions.

 

Why

So we can have row level "table calculations" that can be used as any other dimension or measure.

So we don't need to use custom SQL for this and experience its performance issues.

 

How

It could be done by special rawsql() functions or perhaps extended LoD functionality.

 

Need

Several of the questions collected in  Correlated Subquery  could probably use a window function.

 

About

Window Functions in SQL - Simple Talk

PostgreSQL: Documentation: 9.5: Window Functions

Microsoft SQL Server: OVER Clause (Transact-SQL)

Oracle: Analytic Functions

 

Related

datelag function

Correlated Subquery

 

News

2018-03-12   ... devs ... are working on adding window function support ...  Source

Comments

Vote history