Calculating ended_at column based on event_time and is_active columns...

Count repeating consecutive events as groups in postgresql...

Is it possible to find out the number of items in a row by using window functions in PostgreSQL?...

Running sum excluding rows with duplicate column value...

apply Window.partitionBy for two columns to get n-core dataset in pyspark...

Get the most recent and not null row...

Postgres window function and group by exception...

T-SQL query getting the max of a sub element...

Join two tables side by side...

Selecting a row in SQL (Snowflake) based on String...

Group rows based on changing pattern of a column PySpark...

OVER clause in Oracle...

MySQL - multiple conditions...

Get successive row values without loop in SQL...

Reset Row_Number Window Function...

MySQL Nested aggregation query with selection of specific intermediate items...

Replace missing value with similar row values in same dataset (no joins)...

with SQL, how to drop cases after a long gap in a time series?...

Get count of values in different subgroups...

SQL Row Count Over Partition By...

how to use first_value with reset...

Postgres removing 'smaller' ranges from a 'bigger' range and return a aggregate of r...

Window function query issue?...

Explode (duplicate) records based on timestamp range (PostgreSQL)...

How to find multiple maximum value from same column in SQL Server...

SQL Shift Timeseries (Get Following Row For Multiple Timestamps)...

Get the newest two line per product and get price and date...

Working with accumulated sums and sql partitioning...

snowflake-sql: case when min vs first_value windows function...

Select row A if a condition satisfies else select row B for each group...