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


sqloracleanalytic-functions

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


sqloraclelaganalytic-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...


sqloraclerecursive-queryanalytic-functionscumulative-sum

Read More
Interesting Row_Number() bug...


sqlsql-servert-sqlrow-numberanalytic-functions

Read More
Analytic function windowing clause...


oracleanalytic-functions

Read More
Oracle SQL NTILE - equal distribution...


oracleanalytic-functionsbuckets

Read More
Oracle SQL - distributing into buckets...


oraclesortingplsqlbucketanalytic-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...


sqloracleaggregate-functionswindow-functionsanalytic-functions

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


sqloracleoracle11ganalytic-functions

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


sqloracleoracle11ganalytic-functions

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


oracleanalytic-functions

Read More
Oracle Analytic Rolling Percentile...


oracleoracle11ganalytic-functions

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


oracleplsqlanalytic-functions

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


sqloracleoracle11gwindow-functionsanalytic-functions

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


oraclemergeanalytic-functions

Read More
Incoorect Count Results...


oracleanalytic-functions

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


sqloracledata-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...


sqloracleanalytic-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(*)...


oraclerankanalytic-functions

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


oracleaggregate-functionsanalytic-functions

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


oraclecommon-table-expressionwindow-functionsanalytic-functions

Read More
BackNext