Search code examples
Calculating average number of customers that were contacted before successful conversion...


sqlwindow-functionspresto

Read More
select distinct window function in PostgreSQL...


sqlpostgresqlwindow-functionsrolling-computation

Read More
how do I set up my window function properly? (PostgreSQL)...


sqlpostgresqlwindow-functions

Read More
questions on aggregation functions...


sqloraclewindow-functions

Read More
What is wrong with this running total (cumulative column) in Oracle select with a window function?...


sqloraclewindow-functionscumulative-sum

Read More
Calculate Year-Total, Period-Total and Previous-Year-Total and Previous-Period-Total in a performant...


sql-serverwindow-functions

Read More
Union ALL with partition...


sqlsql-serverunionwindow-functions

Read More
Optimising function which extracts records with a minimum gap in timestamps...


sqlpostgresqlplpgsqlwindow-functionsgaps-and-islands

Read More
running sum with window function...


sqlpostgresqlwindow-functionspostgresql-9.6

Read More
Using aggregate and window function within a sub-query...


sqlsqliteaggregate-functionswindow-functions

Read More
How to understand the results of rows between 2 preceding and current row?...


sqloraclewindow-functions

Read More
Cumulated sum based on condition in other column...


sqlpostgresqlwindow-functionsgaps-and-islandscumsum

Read More
Mysql - Simulate lag with multiple previous rows (not just one)...


mysqlsqlwindow-functions

Read More
Get "circular lag" of a column...


pythonpysparkapache-spark-sqlwindow-functions

Read More
Pyspark advanced window function...


pythonpysparkapache-spark-sqlwindow-functions

Read More
Calculate the rank and apply it following an order...


sqlsql-serverwindow-functionsdense-rank

Read More
Calculating the price difference between two days...


sqlpostgresqlwindow-functions

Read More
How to get rows with last update on column...


sqloraclewindow-functions

Read More
oracle sql question, row between preceding...


sqloraclewindow-functions

Read More
auto increment field in select query statement...


sqlpostgresqlwindow-functions

Read More
Window function inside a pivot, is it possible?...


sqlpostgresqlpivotwindow-functions

Read More
How to add a running count to rows in a 'streak' of consecutive days...


sqlpostgresqlwindow-functionsdate-arithmeticgaps-and-islands

Read More
Rolling active users that were also active in previous days in bigquery...


google-bigquerywindow-functions

Read More
How to joining two tables with missing rows in the last month?...


sqlrpostgresqlwindow-functions

Read More
SQL get only items with all values in column...


sqlpostgresqlwindow-functions

Read More
Sum until threshold value reached and then reset the counter...


sqlpostgresqlwindow-functions

Read More
Calculate moving average using SQL window functions with leading null's where not enough data is...


sqlpostgresqlwindow-functions

Read More
Elegant approach to fetch the first value from each group without using outer query...


sqlpostgresqlgreatest-n-per-groupwindow-functions

Read More
Partition rows where dates are between the previous dates...


sqloraclewindow-functions

Read More
ROW_NUMBER(), PARTITION_BY, TOP 2 MAX If MAX 1st and Last Position...


sqlpostgresqlwindow-functions

Read More
BackNext