Search code examples
SUM with CASE Statements...

sqlgoogle-bigquerycasewindow-functions

Read More
Updating rows among same table in Azure Synapse Analytics...

sql-servert-sqlsql-updatewindow-functionsazure-synapse

Read More
has_been window function?...

sqlamazon-web-servicesamazon-redshiftwindow-functions

Read More
How to join two or more equal consecutive values of column into one in SQLite?...

sqlsqlitecommon-table-expressionwindow-functionsgroup-concat

Read More
Create a column that calculates the percentage of the total value of the previous column...

sqlsql-serverwindow-functionspercentage

Read More
Group users by revenue and years...

sqlpostgresqlaggregate-functionswindow-functions

Read More
Forward (or Backward filling) in postgres...

sqlpostgresqlpandaswindow-functions

Read More
Sql query to regroup audit information...

sqlsql-servert-sqlwindow-functionsunpivot

Read More
Sequence purchases in a table where the sequence is unique to the purchaser...

sqlwindow-functions

Read More
Find transitions from exact values SQL...

sqlwindow-functionspresto

Read More
Use ROW_NUMBER() window function without specifying ORDER BY...

sqloracle-databasewindow-functionsoracle18coracle-spatial

Read More
PostgreSQL return last row in each sequence of same column values (alternation)...

sqlpostgresqlwindow-functions

Read More
Selecting single row for each employee with status_id by priroity...

mysqlmariadbsql-order-bycommon-table-expressionwindow-functions

Read More
Using SQL calculate average value on each sector...

sqlsql-serverwindow-functions

Read More
How to get running percentages or earliest date...

sqlsql-serversql-server-2008window-functions

Read More
Redshift SQL - Partition with CASE expression...

sqlamazon-redshiftwindow-functions

Read More
Oracle "Partition By" Keyword...

sqloracle-databasewindow-functions

Read More
SQL: Merge almost identical lines with start_date and end_date...

sqlpostgresqlwindow-functionsgaps-and-islands

Read More
Using window functions to get first value along with group by sum...

sqlgoogle-bigquerywindow-functions

Read More
Compensating for NULL values in SQL Queries...

sqlsql-servergreatest-n-per-groupwindow-functionsgaps-and-islands

Read More
SQL: Calculating if an ID does NOT appear that did appear in the previous week only...

mysqlsqljoingoogle-bigquerywindow-functions

Read More
Dealing with NULLS in ROW_NUMBER function...

sqlsql-serverwindow-functionsrow-number

Read More
Order subquery results and return first row per ID...

mysqlwindow-functionsmariadb-10.5

Read More
Get most recent streak (consecutive days) for given event and time zone...

sqlpostgresqlwindow-functionsgaps-and-islandstimestamp-with-timezone

Read More
How do I calculate participants session time in this case?...

sqlpostgresqlwindow-functions

Read More
Postgres window function not working as expected...

sqlpostgresqlwindow-functions

Read More
Display # of customers per month that have previous Sale date > 3 months and # of these customers...

sqlamazon-redshiftwindow-functionslag

Read More
What's the difference between RANK() and DENSE_RANK() functions in oracle?...

sqloracle-databasewindow-functions

Read More
Calculate rolling average of a measure based on certain condition from another column...

sqlsql-serversubquerywindow-functionslateral-join

Read More
SQL to omit initial records until a column value is greater than zero...

sqlpostgresqlwindow-functions

Read More
BackNext