Search code examples
Analytic Function SUM returns Average for window with same values...


sqloracle-databaseanalytic-functions

Read More
How to add a flag to the rows after a specific value within a key in Oracle SQL?...


sqloracle-databaselaganalytic-functionslead

Read More
Windowed Average, accounting for gaps...


sqlgoogle-bigqueryanalytic-functionsrolling-average

Read More
Can we use analytic functions to retrieve parents and child in hierarchy?...


sqlsql-serverrecursionhierarchical-dataanalytic-functions

Read More
How to avoid same out time in this query?...


sqlsql-serverdatetimewindow-functionsanalytic-functions

Read More
Oracle SQL Analytic query - recursive spreadsheet-like running total...


sqloracle-databaserecursive-queryanalytic-functionscumulative-sum

Read More
Interesting Row_Number() bug...


sqlsql-servert-sqlrow-numberanalytic-functions

Read More
Analytic function windowing clause...


oracle-databaseanalytic-functions

Read More
Oracle SQL NTILE - equal distribution...


oracle-databaseanalytic-functionsbuckets

Read More
Oracle SQL - distributing into buckets...


oracle-databasesortingplsqlbucketanalytic-functions

Read More
How to calculate moving average value using every nth row (e.g. 24th,48th and 72nd) in sql?...


sqlanalytic-functions

Read More
NoSQL with analytic functions...


mapreducenosqlanalytic-functions

Read More
Find row in related table with closest date...


sqloracle-databaseaggregate-functionswindow-functionsanalytic-functions

Read More
How the get last change timestamp for row?...


sqloracle-databaseoracle11ganalytic-functions

Read More
Convert a sequence of 0s and 1s to a print-style page list...


sqloracle-databaseoracle11ganalytic-functions

Read More
Find Maximal Value of other Rows per Group...


oracle-databaseanalytic-functions

Read More
Oracle Analytic Rolling Percentile...


oracle-databaseoracle11ganalytic-functions

Read More
Updating a column in an Oracle procedure based on other two columns and using a LAG function...


oracle-databaseplsqlanalytic-functions

Read More
oracle SQL select the distinct customers in the past x day rolling period...


sqloracle-databaseoracle11gwindow-functionsanalytic-functions

Read More
How do you shift values down in a column in an Oracle table?...


oracle-databasemergeanalytic-functions

Read More
Incoorect Count Results...


oracle-databaseanalytic-functions

Read More
Group by vs Partition by in Oracle...


sqloracle-databasedata-warehouseanalytic-functions

Read More
Oracle - Increment value...


oracle11gincrementanalytic-functions

Read More
SQL sliding window aggregation (without using window function)...


sqlwindow-functionssliding-windowanalytic-functions

Read More
What is the average salary of the employees who have the highest commission...


sqloracle-sqldeveloperanalytic-functions

Read More
Oracle SQL - How to contrain related records timewise...


sqloracle-databaseanalytic-functions

Read More
Obtaining multiple percentiles (percentile_cont equivalent) in one pass within Teradata...


sqlteradataanalytic-functions

Read More
rank() a group of items by count(*)...


oracle-databaserankanalytic-functions

Read More
How to best calculate n-level aggregation data based on (n-1)-level data (Oracle)...


oracle-databaseaggregate-functionsanalytic-functions

Read More
avg sale of quarter with previous quarter avg sale...


oracle-databasecommon-table-expressionwindow-functionsanalytic-functions

Read More
BackNext