Tag: window-functions

Found 142 results for 'window-functions'.

1) postgresql - Time-series window query for calculating rolling average across group by subquery is inaccurate due to missing rows
2) postgresql - Conditional Select from Window Function
3) postgresql - Using PL/R for clustering geometries
4) postgresql - Return total number of rows and selected (aggregated) data
5) postgresql - PostgreSQL window functions very slow on big table
6) postgresql - How to set a value if certain columns are the same across multiple rows
7) postgresql - Count rows with max per group and additional condition
8) postgresql - Finding earliest connected value over two columns
9) oracle - PL-SQL "LAST_VALUE" function does not give the desired result
10) postgresql - How do I optimize my transaction level running balances cartesian join?
11) postgresql - Convert timestamp type during INSERT
12) sql-server - How to create sums/counts of grouped items over multiple tables
13) postgresql - Maximum sum() of overlapping ranges
14) sql - PostgreSQL unnest() with element number
15) t-sql - Simplifying Function with Recursive CTE and/or Window Function
16) sql-server - Consolidating multiple related queries, each using different window and/or criteria for counting records
17) postgresql - Group by with a break on date
18) postgresql - Postgresql Recursion Query
19) postgresql - How do you select the rolling, most recent value for each person for each month in a range where that most recent value is less than 6 months old?
20) postgresql - Calculate 40 day moving average w.r.t to a field
21) postgresql - Count of 3 consecutive unsynced dates
22) postgresql - Nested aggregate functions over different dimensions
23) postgresql - Aggregate rows for each group of rows
24) postgresql - Transformation of row data based on preceding row for special cumulative sum
25) postgresql - Select row at the nth percentile
26) postgresql - Set non-negative floor for rolling sum, in PostgreSQL
27) postgresql - Check if contiguous date interval exists
28) postgresql - Select longest continuous sequence
29) postgresql - postgres window functions: using CASE to partition by age group
30) sql-server - Selecting Values That Differ From Section Average
31) sql-server - How to select the set of last non-NULL values per column over a group?
32) oracle - Oracle analytic functions - how to get the highest RANKing row?
33) postgresql - In what case is a count(x or null) needed in Gaps and Islands?
34) sql-server - Lead/Lag Implementation in SQL Server 2008 R2: Max memory exceeded
35) mysql - Is it possible to reliably number rows in some order conforming to SQL standard?
36) postgresql - Postgres - window function rank and count
37) postgresql - RANGE clause error within window function
38) oracle - What is the simplest way of excluding the current row from the result of an analytic?
39) postgresql - Scalable query for running counts of events within x previous days
40) mysql - Compare running / cumulative total with static target
41) mysql - Getting rank of row
42) postgresql - Select first row (grouping) + add aggregate function
43) sql-server - If at least a negative number, sum; otherwise just show
44) postgresql - How can I get the latest five scores per user per subject?
45) sql-server - Window Function to get pairs of records and compute the time difference
46) sql - Counting preceding occurences of an event within a given interval for each event row with a window function
47) window-functions - Understand why rank() over doesn't fit to don't select duplicates rows
48) sql-server - How can I write windowing query which sums a column to create discrete buckets?
49) postgresql - Working of window functions and idea window size for window function
50) sql-server - Is it possible to use LAG() with WHERE?